Need help with complex formula

[Letto4135]

Looking for a master to show me the ways.


I can't figure out a formula and its difficult to explain..

I have a large table of data where I have several orders and I want to organize them by most recent.....
And here's the complicated part..
There are several orders I don't want at all.
Each order has a transaction type, material type, product description, date, and location it is going.
I need a formula or series of to narrow the info down specifically by each until i get exactly what i want.
I want to pull out the 18 most recent orders to put the data into a graph so not only is it very specific data it's non repeating...

If your'e a master willing to attempt to help I will email you the spreadsheet if you don't have a problem with it because at this point, I'm lost.

 

[Fazza]

hello

suggest you post some sample input & results data with specific information on how to get the result from the inputs

from the intitial post, it sounds like a query does what you want (so without formulas). so something like below.
SELECT TOP 18 fields
FROM table
WHERE criteria
ORDER BY datefield DESC

 

[Letto4135]

hello

suggest you post some sample input & results data with specific information on how to get the result from the inputs

from the intitial post, it sounds like a query does what you want (so without formulas). so something like below.
SELECT TOP 18 fields
FROM table
WHERE criteria
ORDER BY datefield DESC

Time to google making an excel query i guess. Lol
That does sound like it.. best example I can give of a formula would be if( and( this, this, this) give me k value of if( and) but don't repeat..
=if(and(g:g=h12,b:b=h13,c:c="inventory out"),large(a:a,1),"") ??? I know it doesn't work but that's the way I think about it working..

I am bad at the sample input and results but here goes

Date | order | amount | part desc | part # | trans desc

12/13/16 | 43E5B | 165 | 1.1mm something | something | inventory out
12/13/16 43E5B | 12.5 | 1.1mm something | something | scrap
12/1/16 | 446B7 | 289 | 1.1mm something | something | inventory out

So it looks for 1.1mm something, something and inventory out without repeating order # showing

43E5B
446B7

Reality, I'm looking at over 18,000 entries on this particular part desc. with 100 different locations, another 50 transaction descriptions, and probably a few thousand order numbers

 

[Fazza]

How do you envisage it working? The steps need to be clearly explained.

 

[Peter_SSs]

If your'e a master willing to attempt to help I will email you the spreadsheet ....

Please refer to no. 4 of the Forum Rules and keep all the communication public.

 

[Nishant94]

Are you looking for something like this:

Unknown
	A	B	C	D	E	F
1	Date	Order	Amount	Part Desc	Part #	Trans Desc
2	13/12/2016	43E5B	165	1.1Mm Something	Something	Inventory Out
3	13/12/2016	43E5B	12.5	1.1Mm Something	Something	Scrap
4	01/12/2016	446B7	289	1.1Mm Something	Something	Inventory Out
5
6
7	1.1Mm Something	Something	Inventory Out	43E5B
8				446B7
9
10
Sheet2

Cell Formulas
Range	Formula
D7	{=IFERROR(INDEX($B$2:$B$4,MATCH(LARGE(IF(($A$7&$B$7&$C$7)=($D$2:$D$4&$E$2:$E$4&$F$2:$F$4),$A$2:$A$4),ROWS(D$7:D7)),$A$2:$A$4,0)),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Letto4135]

Yes, that works, but it still repeats the order numbers when there are multiple ones with the same order #...