Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with a formula
HI
I have codes in one section of my worksheet (like 56743) in cells A10:A30 with totals (numbers) in cells B10:B30 Then, I have another section of the worksheet that might have the same codes and might not in cells A40:A60 with totals in cells B40:B60. The totals are calculated different between the two sets ...thus they are separated. My Question is: Is there a formula I can enter, for example in cell C40, that will only enter the total from cell B40 if the code (or number entered) in cell A40 is NOT listed in cells A10:A30? Any help is greatly appreciated.. Thanks in advance, Kimberly |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with a formula
Hi Kimberly,
Try: =IF(ISNUMBER(MATCH(A40,A10:A29,FALSE)),0,B40) Regards, Nate Oliver |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with a formula
Thanks.. that worked!
"Nate Oliver" wrote in message ... Hi Kimberly, Try: =IF(ISNUMBER(MATCH(A40,A10:A29,FALSE)),0,B40) Regards, Nate Oliver |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with a formula
You're welcome.
Hope you caught that 29 was a typo, it should have been 30. Regards, Nate Oliver |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |