Hi once again,
I am so frustrated with this - this is beyond my scope atm. I just do not know how to create a list based on meeting some criteria.
I know it will be quite easy for those well versed with excel.
TIA
Hi once again,
I am so frustrated with this - this is beyond my scope atm. I just do not know how to create a list based on meeting some criteria.
I know it will be quite easy for those well versed with excel.
TIA
No idea at all what you're trying to do
I'm on Windows but that's no issue but I tried to figure out what you are trying to do and I'm sorry, I don't see it.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
use drop down
populate Parts, Line Codes, Net Sales list using the Account ID
Junk at bottom is stuff I am experimenting with
Last edited by bambamclint; 02-08-2019 at 06:28 PM.
Okay got the idea.
If you need a list then I don't think a formula will work, you would have to resort to macro's or just add a pivot table with the required fields with and filter that
I was hoping to avoid a pivot table even though it does work and gets the "desired" result. Appreciate the response.
Can the values (Line_Code & Net Sales) be returned in the same column so that table is the same size?
Could one not "count" the number of rows based on the Account ID or Shop Name and return those through a formula?
Yes but the problem is the increment and I wouldn't know how to do it with formulas
Me either - thats why I am here LOL
I saw someone using Index/Aggregate but I was completely lost.
Please try at
Summary!A8 drag across and down
=IFERROR(INDEX(primary_lines,AGGREGATE(15,6,ROW(primary_lines)/(Hard_Parts!$B$2:$B$200=$A$2),ROWS(A$8:A8))-1,MATCH(A$7,primary_lines[#Headers],)),"")
I edit the header to match with Hard_Parts.
Bo_Ry,
That seems to work like a charm! I have spent a lot of time on this and would have never have come up with that. Really Appreciate it
Happy to help
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
I will once I am able to test it in the environment/workbook that I built. I need to get my Swim Club registration packages done.
It sort of works - I am not sure how and what values it searches for but it is not pulling all the values over
I have attached the sample workbook with real data.
For example, if you select Rolling Mix Concrete the results start at the 21st entry (world Parts Axles/$197.xx).
Another example: Hicklin Motors has data but no results are shown.
What would cause that to happen?
Correction as in Red at A8 drag across and down.
=IFERROR(INDEX(primary_lines,AGGREGATE(15,6,ROW(primary_lines)/(Hard_Parts!$A$2:$A$4000=$A$4),ROWS(A$8:A8))-1,MATCH(A$7,primary_lines[#Headers],)),"")
You have made my day! Thank you1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks