Transaction History by exact code

[makinmomb]

Formula on n2 to y2 to pull down

To search blue box

[makinmomb]

File attached looks as follows

[makinmomb]

Kindly give data search range at 2o,ooo rows

[oeldere]

Why not use the built in filter?

See the attached file.

Why is store 2 exclused (not in your result)?

[makinmomb]

Filter is long , I know that , you have to unclear filter for next query , query work is common so formula is more practical

[makinmomb]

Store 2 excluded , as this is sample data , real data has 22 stores

[oeldere]

Then add in your file, what your input data are (and in which cells, we can find them).

You could mark them with a color (e.g. blue).

[makinmomb]

Blue is the search criteria formula on n2 to y2 to drag down

[oeldere]

a2 = B2&countif($B$2:$B2,$B2)

P2 =VLookup($O$1&Row()-1,$A$2:$M$17,column()-14,0) and drag across

See the attached file.

[makinmomb]

Wow awesome , thank you very much oeldere

[makinmomb]

Hi Oeldere

Program works beyond awesome

Please add me 11 and 12 being november and december
As I don't know to edit those formula

[oeldere]

Please do not PM me.

Just add the question on this forum, so also other forummembers can help you.

I don't see 11 and 12 in the file in #9, so the question is unclear to me.

You get better help adding an excel file without confidential information.

Please also add the expected result manualy in the file.

[makinmomb]

I have not added column 11 and 12 , the formula then not works

[JohnTopley]

If you are inserting two more columns (J & K) then change 14 in the formulae you have been given to 16

=VLookup($O$1&Row()-1,$A$2:$M$17,column()-16,0)

[makinmomb]

Wow I understood you now , thank you very much