Check whether a specific transaction took place within a time period

TamirBasin

New Member
Joined
Apr 11, 2017
Messages
49
Office Version
  1. 365
Platform
  1. Windows
Hi,

How can I calculate whether a specific transaction took place within a time period of one of the Sales (Discounts and allowances table)?

Thanks,
Tamir

Screenshot
guestaccess.aspx


My File
https://basintamir-my.sharepoint.com/personal/tamir_tamirbasin_com/_layouts/15/guestaccess.aspx?docid=1976097f9d69a41769e47a1a9afb422de&authkey=AY61E3tYtZC1R4f_tTpVEnE
 
Not so. For the layout in my screen shot ROW(Table3[[#Headers],[Promotion]] ) returns 9
My point was that it is always the same number...

we gete {1,2,3,4,5} which are the rows of the table, relative to the table.
My point was that it is always the same array...

My question: Why would the SMALL function produce different results? How does it "know" to start from the proper row?

Thank you,

Tamir
 
Upvote 0

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
I don't understand what you are asking. Can you spell it out in more detail?
 
Upvote 0
Hi Peter,

As I was trying to explain it better for you to understand....the penny dropped and I understood what you explained to me :))))

The expression: ROW(Table3[Promotion])-ROW(Table3[[#Headers],[Promotion]]) always produce the same array of rows :{1,2,3,4,....1033)
and when it divides itself by 1 or 0, it produces an array of errors and a single value which is the desired row (location) which in return goes into the Index formula.

Thank you for your help and patience.

Till next question,

Tamir
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,210
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top