Nelson78
Well-known Member
- Joined
- Sep 11, 2017
- Messages
- 526
- Office Version
- 2007
Hello everybody.
I have a big table of data (it could join 20k records deployed from column A to column AF).
I have to do some operations which, in my opinion, could require a dictionary.
The driver is in column B and it could be, to simplify, a list of surname (suppose two of them repetead in the 20k records, let me say SMITH and ROBERTSON, but they could be more).
Column N is populated by positive integers.
Column AF is populated by dates.
Column J is populated by positive integers, and it is what I have to sum.
I need to calculate the sum in column J of combinations in columns B/N/AF
SMITH, value in column N = 0, values in column AF between two variables of date type (suppose date1 and date2), sum of values in column J.
SMITH, value in column N > 0, values in column AF between two variables of date type (date1 and date2), sum of values in column J.
ROBERTSON, value in column N = 0, values in column AF between two variables of date type (date1 and date2), sum of values in column J.
ROBERTSON, value in column N > 0, values in column AF between two variables of date type (date1 and date2), sum of values in column J.
How could I perform the task?
I have a big table of data (it could join 20k records deployed from column A to column AF).
I have to do some operations which, in my opinion, could require a dictionary.
The driver is in column B and it could be, to simplify, a list of surname (suppose two of them repetead in the 20k records, let me say SMITH and ROBERTSON, but they could be more).
Column N is populated by positive integers.
Column AF is populated by dates.
Column J is populated by positive integers, and it is what I have to sum.
I need to calculate the sum in column J of combinations in columns B/N/AF
SMITH, value in column N = 0, values in column AF between two variables of date type (suppose date1 and date2), sum of values in column J.
SMITH, value in column N > 0, values in column AF between two variables of date type (date1 and date2), sum of values in column J.
ROBERTSON, value in column N = 0, values in column AF between two variables of date type (date1 and date2), sum of values in column J.
ROBERTSON, value in column N > 0, values in column AF between two variables of date type (date1 and date2), sum of values in column J.
How could I perform the task?