LinkBack URL
About LinkBacks
All
have a data set with client id and most dates of activity....
I would like to be able to include within a report the date of first activity and the most recent date of activity....
please see attached sample worksheet...
rgds and TIA
Shaz0503
All
have a data set with client id and most dates of activity....
I would like to be able to include within a report the date of first activity and the most recent date of activity....
please see attached sample worksheet...
rgds and TIA
Shaz0503
First Apply the sorting for both column-A and Column-B
In F3 Cell
=VLOOKUP(E3,$A$3:$B$18,2,FALSE)
In G3 Cell
=LOOKUP(2,1/($A$3:$A$18=E3),$B$3:$B$18)
Drag both the formula's down..
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
thx sixth sense - will have a look at these
Thanks Sixthsense
The first formula works fine... but the second one doesn't appear to work... get n/a...
... any ideas
rgds
Have you did this before applying the formula?Originally Posted by shaz0503
Sixthsense
I sorted by column a and then by column b as suggested.......
S
Refer the attached file for details
Sixthsense
I think it may be because I am referring between two sheets.... what do you think...
I have a summary worksheet and a main data worksheet....the summary worksheet will return the value from the main data sheet....
rgds
Referring to some other sheets is not an issue, but ensure that both the ranges of lookup should have a constant range of cells
.... please see attached file for your suggestions - I have used your formula on sheet 1
... I am thinking this is going to be something really simple I am missing
rgds
S
Your current formula refers to Employee Number In Sheet1 and matching it with Sheet2. But in sheet2 there is no employee no at all
In M2 cell of Sheet1
=LOOKUP(2,1/(Sheet2!$C$2:$C$1201=A2),Sheet2!$F$2:$F$1201)
So I suspect it should be B2
=LOOKUP(2,1/(Sheet2!$C$2:$C$1201=B2),Sheet2!$F$2:$F$1201)
Sixthsense
why oh why is it always such a simple thing....
many thanks for your time
Shaz0503
You can mask the error cells by way of adding an Iferror() function.
=Iferror(YourCurrentFormula,"Your Personalised Text Here")
So the formula will looks like this...
=IFERROR(LOOKUP(2,1/(Sheet2!$C$2:$C$1201=B2),Sheet2!$F$2:$F$1201),"")
=IFERROR(VLOOKUP(E3,$A$3:$B$18,2,FALSE),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks