i want to create a new tab based on the status (see attached file)
vlookup
-
-
-
Re: vlookup
Hi fedo.
Your request is not so clear. Pls, explain it a little more or even better upload a small sample workbook.
-
Re: vlookup
ok
-
Re: vlookup
i uploaded the sample workbook, i have huge database with duplicated value (status) i want to create groups based on their status without using filter
-
Re: vlookup
Hi
Pls don't be unpatient(regarding your pm).
In A2 of your second sheet, put this ARRAY formula. Copy down and across. I did an example for Open Status. Same way for the others.
=IF(ISERROR(INDEX(Sheet1!A$2:A$1000;SMALL(IF(Sheet1!$A$2:$A$1000="Open";ROW(Sheet1!A$2:A$1000)-1);ROW(Sheet1!A1))));"";INDEX(Sheet1!A$2:A$1000;SMALL(IF(Sheet1!$A$2:$A$1000="Open";ROW(Sheet1!A$2:A$1000)-1);ROW(Sheet1!A1))))
Does this work for you?
-
-
Re: vlookup
fedo,
The forum rules require thread titles to accurately describe your thread.
Based on your post #3 and the solution offered by Fotis, "VLOOKUP" does not define your need.Please make an immediate edit your thread title and change it to accurately describe this thread.
[COLOR="navy"]How to edit your post or thread title or upload an attachment[/COLOR]
1. Click the EDIT POST in the gray band immediately below your post
2. Click Go Advanced
3. Edit the post or thread title
4. To upload: scroll down to Manage Attachments -
Re: vlookup
Also, I'm curious to ask this:
This was your PM, 1 hour after your first post.
Quote[h=2]vlookup[/h] [INDENT] iam still waiting for your reply [/INDENT]
Now WE wait for your reply.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!