Good morning
This should be easily done if not in Excel tehn in VBA
I need a simple code to resolve the following
I have a table with cells filled with numbers, or words, and cells which are empty, randomly.
I want to automatically depict next to each row the following example. row as 121, where the contents of that row would be
Example:
The contents of the row would be as below and the result would show, on a cell net to the row, 121
Filled cell / Empty cell /Filled Cell / Filled cell / empty cell / Filled cell = 121
Note: empty cells can be consecutively more than one and the result would still be 121, such as below
Filled cell / Empty cell /Filled Cell / Filled cell / empty cell / empty cell / Filled cell = 121
Some other examples
Filled cell / Filled Cell / Filled cell / empty cell / empty cell / Filled cell = 31
Filled cell /Filled Cell / Filled cell / empty cell / empty cell / empty cell = 3
empty cell / empty cell / Filled cell /Filled Cell / Filled cell = 3
Hope someone can help.
Thank you for your attention
Regards
This should be easily done if not in Excel tehn in VBA
I need a simple code to resolve the following
I have a table with cells filled with numbers, or words, and cells which are empty, randomly.
I want to automatically depict next to each row the following example. row as 121, where the contents of that row would be
Example:
The contents of the row would be as below and the result would show, on a cell net to the row, 121
Filled cell / Empty cell /Filled Cell / Filled cell / empty cell / Filled cell = 121
Note: empty cells can be consecutively more than one and the result would still be 121, such as below
Filled cell / Empty cell /Filled Cell / Filled cell / empty cell / empty cell / Filled cell = 121
Some other examples
Filled cell / Filled Cell / Filled cell / empty cell / empty cell / Filled cell = 31
Filled cell /Filled Cell / Filled cell / empty cell / empty cell / empty cell = 3
empty cell / empty cell / Filled cell /Filled Cell / Filled cell = 3
Hope someone can help.
Thank you for your attention
Regards