# Posts by Robert Mika

• ## counting number of days between anniversary day and payment due date

Re: counting number of days between anniversary day and payment due date

You are welcome.

• ## Find Column Header Name for the Max in a Row

Re: Find Column Header Name for the Max in a Row

Coudl you post your workbook with example?

• ## counting number of days between anniversary day and payment due date

Re: counting number of days between anniversary day and payment due date

=\$G\$4-DATE(YEAR(D5),MONTH(E5),DAY(E5))
G4 is 31/07/2013
The answer is 1583 for the first line.
Otherwise Could you state the disired result?

• ## counting number of days between anniversary day and payment due date

Re: counting number of days between anniversary day and payment due date

Could you upload your workbook?

• ## Sum values adjacent to random entries of a particular word in a worksheet

Re: Sum values adjacent to random entries of a particular word in a worksheet

You are welcome.

• ## Calculate number of hours worked

Re: Calculate number of hours worked

Are the only two formats or you can have more?
Is this 8:30 4:30 morning or afternoon?
How do you know this?

• ## Sum values adjacent to random entries of a particular word in a worksheet

Re: Sum values adjacent to random entries of a particular word in a worksheet

=SUM(IF(C4:V24="interest",D4:W24))
Confirm Control+Shift+Enter
or
=SUMPRODUCT(--(C4:V24="interest"),D4:W24)

• ## VLookup/Index to return multiple values

Re: VLookup/Index to return multiple values

So the Track tab you need all 27786 first, then 28286 ....
This is possible but the user will have to add the numbers.
Is the outocme in Tracj what you expected to return?

• ## Retrieve data in a cell from value in another cell

Re: Retrieve data in a cell from value in another cell

You are welcome.

• ## Retrieve data in a cell from value in another cell

Re: Retrieve data in a cell from value in another cell

I have changed the formula.
Spam was there as you had "x" in column Cforum.ozgrid.com/index.php?attachment/55643/

• ## Retrieve data in a cell from value in another cell

Re: Retrieve data in a cell from value in another cell

Your formula is the same as mine just for Excel 2003 or previous.
IFERROR was introduced in v.07.
Can you post your workbook with te not working solution?

• ## Excel formula for project dates - kind of confused!!

Re: Excel formula for project dates - kind of confused!!

Quote from GreekCPA;678867

I think that worked. It looks so simple, but it really threw me for a loop this morning. THANK YOU!!!!

You are welcome

• ## Excel formula for project dates - kind of confused!!

Re: Excel formula for project dates - kind of confused!!

Hello and welcome.
C5
=IF(TODAY()<=A5,0,TODAY()-A5)
D5:
=B5-A5-C5
or
=IF(A5>B5,0,B5-A5-C5)

• ## Array formula looking at a specific value in Column A skip a row and return a value

Re: Array formula looking at a specific value in Column A skip a row and return a val

Could provide an example on how this should look like?

• ## Retrieve data in a cell from value in another cell

Re: Retrieve data in a cell from value in another cell

forum.ozgrid.com/index.php?attachment/55608/

• ## Calculating overtime in Excel

Re: Calculating overtime in Excel

Could you post your spreadsheet?

• ## Vlookup needs revision

Re: Vlookup needs revision

I got problem with download so here is a formula/:
=IF(ISNA(INDEX(Sheet2!\$A\$2:\$AA\$46312,MATCH(\$C6,Sheet2!\$F\$2:\$F\$46312,0),MATCH(H\$5,Sheet2!\$A\$1:\$AA\$1,0))),"",INDEX(Sheet2!\$A\$2:\$AA\$46312,MATCH(\$C6,Sheet2!\$F\$2:\$F\$46312,0),MATCH(H\$5,Sheet2!\$A\$1:\$AA\$1,0)))