| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Augmenting an integer in a column to reflect duplicates in another
In article , Claus Busch
writes Hi Colin, Am Tue, 10 Jun 2014 21:05:12 +0100 schrieb Colin Hayes: BTW I wanted also to colour the rows where changes have been made to red. So where the quantity has been updated , that row would be coloured red. have another look in OneDrive Regards Claus B. Claus You are going to hit me! The routine needs to *ignore* blanks in the Bcode column. Sometimes some cells will be empty in this column , but it mustn't count them as the same and then adjust quantities. This is really important. Can it be made to disregard blanks in the Bcode column? Sorry for being a nuisance.... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Augmenting an integer in a column to reflect duplicates in another
Hi Colin,
Am Dienstag, 10. Juni 2014 22:20:50 UTC+2 schrieb Colin Hayes: In article , Claus Busch Sometimes some cells will be empty in this column , but it mustn't count them as the same and then adjust quantities. This is really important. sorry for the delay, my news server is off. I modified the code and the rows with blank cells will remain and will not be count. Have another look in OneDrive Kind Regards Claus |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need column to reflect year 2008 dates | Excel Discussion (Misc queries) | |||
| Find duplicates, sum column then delete duplicates | Excel Programming | |||
| changing html code to increase column width does not reflect in ex | Excel Discussion (Misc queries) | |||
| how can i subtract single integer value from the entire column | Charts and Charting in Excel | |||
| Selecting a column with an integer | Excel Discussion (Misc queries) | |||
Hybrid Mode
