Search results

I just want to say THANK YOU to Sara and Smallman.

My name is Tina and I do some excel edits/coding at work. Though, I am NOT an excel expert at all. Chandoo had been really helpful recently. I'm glad I joined chandoo and will be seeking help from chandoo from now on, so be prepared to help!! I really appreciate everyone's help. Thank you!

Correction: I meant find JULY, not January for Condition 2. And the CORRECT FORMULA for MAX is: =MAX((Sheet3!$A$2:$A$500="EEE")*(MONTH(Sheet3!$B$2:$B$500)&YEAR(Sheet3!$B$2:$B$500)="12013")*(Sheet3!$C$2:$C$500))

I'm trying to COUNT the number of times the data appears using 3 conditions, which I'll be referencing from another sheet. Condition 1: Find 'EEE' in column A. Condition 2: In column B ('DATE' in format MM/DD/YEAR), find January, "<=07/31/2013" and ">=07/01/2013". Condition 3: In...

Thank you very much to all for helping out, especially to SAM. I'd also like to apologize to SAM. Your formula worked because I just tried your codes and it works. But for some reason, when I do the same thing in my final spreadsheet, then it doesn't work. The file is saved as '.xlxs', but...

I did do a CTRL+SHIFT+ENTER and even the brackets show up. Though, the value I get is 0. How can we debug that?

Thank you SAM, though, the output that I received was 0. I've copied and pasted a few data below. I think this might help to understand the process. NAME DATE HOURS EEE 1/14/2013 0.75 CCC 2/21/2013 2 EEE 2/28/2013 2 EEE 1/28/2013 3 CCC 3/7/2013 0.75 ABC 2/13/2013 6.5...

I'm trying to find the MAX number using 3 conditions, which I'll be referencing from another sheet. *Remember, condition 1 and 2 must be true ALWAYS before condition 3 can take place. Condition 1: Find 'EEE' in column A. Condition 2: In column B ('DATE' in format MM/DD/YEAR), find January...