Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retrieve value from a range of cells
Hello Experts! I usually post for help in the programming section. I'm looking for a formula that looks at a range of cells (say A1:A20) and retrieves the value within that range. In those ranges, each cell has a formula that will return a value if the criteria is true. In those ranges there will only be one number, because only one can be true at a time. I just need to get that value in another cell. I tried to do =sum(A1:A20), but the formula doesn't recognize the values as numbers (I guess). Any help, much appreciated, EMoe -- EMoe ------------------------------------------------------------------------ EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183 View this thread: http://www.excelforum.com/showthread...hreadid=553291 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retrieve value from a range of cells
Do you have some samples of formulas and what the return value might be. Will all the formulas have a value -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=553291 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retrieve value from a range of cells
EMoe, If your range A1:A20 contains values stored as text you could try this to retrieve the data and convert to a number. =IF(ISNA(VLOOKUP("*",A1:A20,1,)*1),"",VLOOKUP("*", A1:A20,1,)*1) If there are no values, VLOOKUP returns the N/A error so by adding the IF ISNA to the formula, it will return a blank cell instead. Multiplying by 1 converts to a number. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=553291 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retrieve value from a range of cells
Thanks Noob & Steve. What I had was, in cell B2, I was extracting a process value, using a formula, from another application, using an addin. The value in that cell, for example would be a 1. Which is a logic true value, simply stating that a silo is selected (1=Selected, 0=Not Selected). I had a formula in the ajacent cell C2 *=If(B2,=1,"1","") *which means that if the cell has a 1, then be 18 (which would be silo 18). Well from B2:B20 are silo's 1-18. Only one silo can be selected at a time. So what I was looking for was a formula that would look down C2:C20 and pick out the only value that was there. The other cells would be a 0. I couldn't get your formula to work Steve. What I ended up with was changing the above formula from what you see to *=If(B2=1,1,0). *At the bottom of the range I have *=sum(C2:C20), *and I get the value that I need. Sorry I wasn't clear in the beginning. I'll be glad to look at any other solution that you may have. :) Thanks a bunch again, EMoe -- EMoe ------------------------------------------------------------------------ EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183 View this thread: http://www.excelforum.com/showthread...hreadid=553291 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to hide blank cells in a range | Excel Discussion (Misc queries) | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Count cells in one range based on parameters in another range | Excel Worksheet Functions |