Looking to combine the two formulas below where G51 displays in alphabetical order and then G52 displays in alphabetical order right below, I have successfully joined the two formulas but cant get the right sort order that I'm looking to achieve - Thanks in advance.
=FILTER(SORTBY('CDComp'!D:D,1),'CDComp'!A:A=G51)
and
=FILTER(SORTBY('CDComp'!D:D,1),'CDComp'!A:A=G52)
Try this:
Formula:
Please Login or Register to view this content.
Please see the yellow banner at the top of the page.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
With the below formula I'm able to get all the results I'm looking for however is does not sort correctly , just groups all data together, I need separated out A31 with A32 right below. Example A is using below formula, column C is how I would like it to sort.
=UNIQUE(SORTBY(FILTER('CDComp'!D:D,('CDComp'!A:A=A31)+('CDComp'!A:A=A32)),1,-1))
Last edited by Ctromb; 11-04-2021 at 04:18 PM. Reason: adding attachment
The following formula, pasted into cell A3 on Sheet1 and copied down to cell A29, produces the same list as given in column C:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Exactly what I was looking for, Thank You for your time, I look forward to dissecting and trying to understand each step.
With dynamic arrays you can useFormula:Please Login or Register to view this content.
Thank You for your time, looking back at my attempts I was close to this but never quite got it right - Thanks Again.
Glad to help & thanks for the feedback.
Glad that you got a workable formula. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks