Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Help for a BIG Calculation
I have a formula as under in Colm J starting from Row 2 & down to Row 55000.
=IF(SUMPRODUCT(--($A2=$A$2:A2),--($C2=$C$2:C2),--($E2=$E$2:E2))1,0,1) I am using the formula to determine unique supplier count based on region/Supplier/Commodity. This formula slows down the workbook & my attempts to do manual calculation (shift+F9) is not responsive. The Calculation Cells : information is not progressing beyond 5% and finallt Excel says, it is not responding. Help Please Can anybody help by devising a macro |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Help for a BIG Calculation
You might find this better.
In F2 add =A2&C2&E2 In G2, add =--(COUNTIF($F$2:F2,F2)=1) copy F2. G2 down -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ananth" wrote in message ... I have a formula as under in Colm J starting from Row 2 & down to Row 55000. =IF(SUMPRODUCT(--($A2=$A$2:A2),--($C2=$C$2:C2),--($E2=$E$2:E2))1,0,1) I am using the formula to determine unique supplier count based on region/Supplier/Commodity. This formula slows down the workbook & my attempts to do manual calculation (shift+F9) is not responsive. The Calculation Cells : information is not progressing beyond 5% and finallt Excel says, it is not responding. Help Please Can anybody help by devising a macro |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to go to cell based upon a calculation | Excel Discussion (Misc queries) | |||
Product calculation macro | New Users to Excel | |||
MACRO TO SET THE AUTOMATIC CALCULATION | Excel Discussion (Misc queries) | |||
how to run a macro when a calculation equals a certin number | Excel Worksheet Functions | |||
how to run a macro when a calculation equals a certin number | Excel Worksheet Functions |