Posts by Robert Mika


Re: Find Column Header Name for the Max in a Row
Coudl you post your workbook with example?


Re: Find Column Header Name for the Max in a Row
forum.ozgrid.com/index.php?attachment/55666/
Does this help?

Re: counting number of days between anniversary day and payment due date
Quote from Wafoun;679179hi
i am trying to get the number of days from last time ticket paid till todate, considering the day & month of the hiring date but the year of the last time paid.
say
AAA hired on 15Nov2001 receives a ticket every 24 months; received last ticket in Nov 2011.i want to count
the number of days between 15Nov 2011 until 31Jul2013 (dd & mm are from joining date yyyy from last time paid)
i have a list of 1200 names with different dates of joining and different dates of payments.
thank youCould you upload your workbook?


Re: Calculate number of hours worked
Quote from sabal87;679028I tried looking at old threads, but I can't seem to find anything that works for my case.
I have a time sheet similar to the one below.
[TABLE="width: 500"]
[tr][td]day
[/td][td]time in
[/td][td]time out
[/td][td]time in
[/td][td]time out
[/td][td]hours worked
[/td][/tr][tr][td]Monday
[/td][td]8:30
[/td][td]4:30
[/td][td][/td][td][/td][td][/td][/tr][tr][td]Tuesday
[/td][td]8
[/td][td]12:30
[/td][td]1:30
[/td][td]5
[/td][td][/td][/tr]
[/TABLE]I'm trying to write a code to calculate the hours worked (in both cases 8 for the example above). I've tried different number formats, but I can't find one that works.
Any ideas or comments would be greatly appreciated
Are the only two formats or you can have more?
Is this 8:30 4:30 morning or afternoon?
How do you know this? 

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? 
Re: Calculating overtime in Excel
Try if this works:
forum.ozgrid.com/index.php?attachment/55647/ 
Re: Help inserting into x and y table:
Are you sure?forum.ozgrid.com/index.php?attachment/55645/

Re: Retrieve data in a cell from value in another cell
You are welcome.

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/ 
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? 
Re: Excel formula for project dates  kind of confused!!
Quote from GreekCPA;678867I think that worked. It looks so simple, but it really threw me for a loop this morning. THANK YOU!!!!
You are welcome

Re: Excel formula for project dates  kind of confused!!
Hello and welcome.
C5
=IF(TODAY()<=A5,0,TODAY()A5)
D5:
=B5A5C5
or
=IF(A5>B5,0,B5A5C5) 

Re: Retrieve data in a cell from value in another cell
Quote from Tikigaq75;678677Hi,
I have an inventory list in one column and an "x" in the next column if the item needs to be purchased. i'd like to create a shopping list from these 2 columns. What formula do i use to create the list. I'm trying to retrieve the item that has an "x" and would like to create a column of all those that have an "x". I know i can use: =if(isblank(c2),"",c1), however I'll have multiple blank cells that dont contain the "x".forum.ozgrid.com/index.php?attachment/55607/
Thanks!

Re: Calculating overtime in Excel
Could you post your spreadsheet?

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)))