LinkBack URL
About LinkBacks
Hi,
pls help me with a excel formula to get result as in the attached file.I tried using autofilter but not able to acheive.
Thanks
Shreeja
Hi,
pls help me with a excel formula to get result as in the attached file.I tried using autofilter but not able to acheive.
Thanks
Shreeja
do you want MACRO or Function ?
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
excel formulas will be good.
In C17 Cell - Array Formula - Requires CTRL+SHIFT+ENTER
=IFERROR(INDEX($C$2:$E$11,SMALL(IF($C$2:$C$11=$C$14,ROW($C$2:$C$11)-MIN(ROW($C$2:$C$11))+1),ROWS($1:1)),COLUMNS($A:A)),"")
Drag it down and right...
Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.
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
Try this Attached macro file
is it what u looking for
Thanks sixth sense, it works well..
But I need to pull only "PENDING" from HEADER 2. this formula pulls all rows based on drop down criteria from HEADER 1.
I need to filter drop down criteria from HEADER 1 and criteria "PENDING" (fixed) from HEADER 2 and return entire available rows.
I Just add that criteria to Sixthsense Function
=IFERROR(INDEX($C$2:$E$11,SMALL(IF(($C$2:$C$11=$C$14)*($D$2:$D$11="PENDING"),ROW($C$2:$C$11)-MIN(ROW($C$2:$C$11))+1),ROWS($1:1)),COLUMNS($A:A)),"")
replace that with above
Try this revised formulaOriginally Posted by shreeja178
=IFERROR(INDEX($C$2:$E$11,SMALL(IF(($C$2:$C$11=$C$14)*($D$2:$D$11="Pending"),ROW($C$2:$C$11)-MIN(ROW($C$2:$C$11))+1),ROWS($1:1)),COLUMNS($A:A)),"")
Edit: Hm... Naveed Raza has already given the addition of condition
Last edited by :) Sixthsense :); 11-04-2014 at 03:01 AM.
Thanks Naveed & thanks Sixth sense.. both works perfectly.
Glad to Help
hI, Try this in C17 and drag it across and down
Formula:
Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
Ha ha No rep for me (from the OP)Glad to Helplol
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks