• ## tzaharia

There is no available content written by tzaharia
• ### Recent Forum Posts

#### Excel - Data Validation syntax

I don't think that data validation in cell K25 (what you asked for) will do anything, so I'm guessing you've put that data validation in other cells ...

p45cal Today, 10:56 PM

#### Excel - Data Validation syntax

Thanks for your response! A User (Sergio) within another forum provided me with a very good solution, allowing me to apply it within 'Data Validation'...

Steve-SDC Today, 08:43 PM

#### Excel - Data Validation syntax

You can't do data validation on the result of a formula. However you can do something along the lines of:[CODE]=IF((J22*K24)+1...

p45cal Today, 07:20 PM

#### Excel Count Unique cells with given criteria

Test this one thoroughly; I haven't:

Code:
=SUMPRODUCT(--(RIGHT(A1:F6,2)="AA"),MMULT(--(ISODD(ROW(A1:F6))),--(ISODD(COLUMN(A1:F6)))),1/COUNTIF(A1:F6,A1:F6))
...

p45cal Today, 06:35 PM

#### Need a formula that calculates how many days in a given month between two given dates

…not been back to your computer recently then?...

p45cal Today, 05:57 PM