Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with formula
Hello All,
My problem is I got this formula, which achieve the results I want apart from one solution. The solution that I am looking for this formula isn't happening. The equation is: - =IF(OR(D15="",COUNTBLANK(D17:D20)0),"",IF(COUNTIF (D17:D20,D15)=4,D15,MIN(D17:D20))) The solution that I am looking for if any number is selected out of D17:D20 it should be display in D15, but the equation you must select all 4 cells from D17:D20 for the min value to display in D15. Anyone there that can help me? many thanks ims |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with formula
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with formula
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with formula
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with formula
Hi ims,
If my interpretation of your aim is correct, then I'm almost certain there isn't a formula that will do that. I could email a worksheet with the code inplace if you like. Ken Johnson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with formula
Many thanks Ken but No thanks, I have too many formulas on one sheet
with the same output. Cheers anyway Ims Ken Johnson wrote: Hi ims, If my interpretation of your aim is correct, then I'm almost certain there isn't a formula that will do that. I could email a worksheet with the code inplace if you like. Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another formula problem | Excel Discussion (Misc queries) | |||
Formula Problem | Excel Discussion (Misc queries) | |||
Formula Problem | Excel Worksheet Functions | |||
formula problem | New Users to Excel | |||
formula problem | Excel Programming |