campos1578
New Member
- Joined
- Jan 3, 2020
- Messages
- 22
- Office Version
- 365
- Platform
- MacOS
Hey Guys,
I've been trying to find the right formula practically all day.
I've randomly generated Items Numbers and Order Numbers from a separate worksheet and Copy/Pasted into this worksheet.
Column A has item numbers which may repeat. Column B also has Order Numbers that may repeat. Column C is using the vlookup reference from a different worksheet
My intent: Find the maximum number of Item numbers that appear in the maxim amount of Order Numbers and return in a list
Examples
1 - Run formula that finds the maximum combination of Item numbers that appear in the maxim amount of Order Numbers and return in a list
1- Type an Item Number into cell E2 and generate a list of Order numbers which have that item number from column A vertically starting at F2.
2 -Type in 1 item number in E2 or type in multiple Item numbers (Possibly D2 and E2) and return list of orders that match the criteria for two
I want to input a number in cell E2
I've been trying to find the right formula practically all day.
I've randomly generated Items Numbers and Order Numbers from a separate worksheet and Copy/Pasted into this worksheet.
Column A has item numbers which may repeat. Column B also has Order Numbers that may repeat. Column C is using the vlookup reference from a different worksheet
My intent: Find the maximum number of Item numbers that appear in the maxim amount of Order Numbers and return in a list
Examples
1 - Run formula that finds the maximum combination of Item numbers that appear in the maxim amount of Order Numbers and return in a list
1- Type an Item Number into cell E2 and generate a list of Order numbers which have that item number from column A vertically starting at F2.
2 -Type in 1 item number in E2 or type in multiple Item numbers (Possibly D2 and E2) and return list of orders that match the criteria for two
I want to input a number in cell E2