qureshi2016
New Member
- Joined
- Jan 7, 2016
- Messages
- 8
Rows delete formula as per range of cell values with counter to define how many rows to be deleted
Hi,
I have DB with 50000 rows i have specific cell value A:A
MAX cell value countIF of each specific value of A:A = 31. (Let say Abraham name came in 31 rows in column A:A similary steve also 31 no value will NOT go above 31 as system rule.
Requirement :
I want to use cell value A:A as reference rage for row deletion and would like to delete 5 rows from DB per cell Value
Example
Cell Range: A:A
How many rows you would like to delete : 4 (lets say 4 so it will delete 4 rows as per cell value .
Task:
SO COUNTIF of cell value 31 and new request for specific customer came i am able to delete rows with counter lets say 4 to add four new records in DB.
Bets of Luck!
I love it if its MACRO in vbscripts
Hi,
I have DB with 50000 rows i have specific cell value A:A
MAX cell value countIF of each specific value of A:A = 31. (Let say Abraham name came in 31 rows in column A:A similary steve also 31 no value will NOT go above 31 as system rule.
Requirement :
I want to use cell value A:A as reference rage for row deletion and would like to delete 5 rows from DB per cell Value
Example
Cell Range: A:A
How many rows you would like to delete : 4 (lets say 4 so it will delete 4 rows as per cell value .
Task:
SO COUNTIF of cell value 31 and new request for specific customer came i am able to delete rows with counter lets say 4 to add four new records in DB.
Bets of Luck!
I love it if its MACRO in vbscripts
Last edited:
