Keep only selection of cells from a database for further lookup matching..

In Sheet2 insert a new blank row at the top of the sheet, then put this formula in cell AB2:

=IF(A2="Company Name",COUNTIF(A$2:A2,A2),IF(A2="Email",MAX(AB$1:AB1)+0.5,""))

Copy this down as far as you need to the bottom of your data.

Create a new sheet with the column heading "Name" in A1 and "Email" in B1, and put this formula in A2:

=IFERROR(INDEX(Sheet2!F:F,MATCH(ROWS($1:1),Sheet2!AB:AB,0)),"")

and this one in B2:

=IFERROR(INDEX(Sheet2!F:F,MATCH(ROWS($1:1)+0.5,Sheet2!AB:AB,0)),"")

then copy these down as far as you need to.

Hope this helps.

Pete

Dear Fotis,

Hi! Nice to hear from you!
Thank you for noticing, I have removed the sensitive data and re-posting the attachment.


Hello Pete,

ThanX for the feedback, will try it in a while and let know!

BR
ilias

Hello Pete,
..meaning with ''cell AB2''? If I merge cells A and B, excel wont let me paste the formula.
If I place the formula in cell A2 or B2 (have already inserted the new row) and drag down , I get zeros ''0''..
Is it possible to edit the revised example I posted and send it back?

thank you

See attached file. I think you are a bit confused as to where to put the first formula - in column AB of Sheet2, shown in blue.

Hope this helps.

Pete

Thank you, will see this (from home) and revert.

Yes, exactly what I need!
Appreciate your help!