Hi all
I have a list of clients in C2 to C125 and projected revenue in G2 to G125
I want to be able exract them in to separate lists by value; over 200k, 100-200k, 50-100k, 25-50k, 10-25k and 3-10k
Ideally these lists would reside on a separate tab.
I think I need an array, but I am not having much look being able to do it?!
Thanks!
Last edited by adamlamping; 09-30-2016 at 03:33 AM.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
done...thanksOriginally Posted by shukla.ankur281190
There is not mentioned expected result in attachment.
Please explain with expected result.
See if is this what you want
In 'After' sheet use a helper column in column A from A4
Formula:
Please Login or Register to view this content.
where After!$A$1 is lower limit and After!$B$1 is the upper limit (or empty)
In 'After' sheet in columns B:E from B4 to E4 use the following formula and copy down and right
Formula:Please Login or Register to view this content.
See the file for clarification
Thanks for this...See if is this what you want
In 'After' sheet use a helper column in column A from A4
Formula:Please Login or Register to view this content.
where After!$A$1 is lower limit and After!$B$1 is the upper limit (or empty)
In 'After' sheet in columns B:E from B4 to E4 use the following formula and copy down and right
Formula:Please Login or Register to view this content.
See the file for clarification
what I was after was another tab with tables for each revenue band (listed above) and the clients that fit within that band.
I'd also like to know which clients each "lead" and "Support" were responsible for and the amount of revenue each lead and support was responsible for
Does that make sense
Hi
1) you can copy the 'After' sheet as many as you need and change A1 and B1 according
The second question can be solved with a new column with the rank of each Client (I suppose)
See attached:
formula
=IFERROR(INDEX(Before!$A$1:$D$24,AGGREGATE(15,6,ROW($D$2:$D$24)/(--(Before!$D$2:$D$24>$H$2)*--(Before!$D$2:$D$24<=$H$3)),ROWS($A$1:$A1)),COLUMNS($A:A)),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks