Hi im trying to get a time from a row with two lookup criteria the issue im having is i cant bring the data back because of the gap between the names in column A please see attached.
example
Luke Andrews Phone would be 02:03:04
If you can help, THANKS!!
With the macro below to fill the gaps.
After that with an pivot table.
See the attached file.
Sub filldata_acending_incolumnA() 'from top to below (acending) Range(Range("a2"), Cells(Rows.Count, 3).End(xlUp).Offset(, -2)). _ SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=R[-1]C" End Sub
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi thank you for your reply, I cant fill in the gaps it needs to be the same layout without macros also
And why is that?
I dump that data and on a daily basis, I was just looking for a formula
Then it is a small job to run to macro to fill the gaps.
It will make it much easier to find a formula that fits your needs.
try this.. hope this works..
or you can do it like this.. i changed you table..
=OFFSET(A3,MATCH(E4,$A$4:$A$20,0)+LOOKUP(F4,{"chat","email","phone","Text"},{0,1,2,3}),2,1) should do it
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thank you all, MarinDWilson that worked perfectly! Thank you all!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks