I have a custom function for grouping of numbers named GroupN, which is given by John Jairo V sir.
In the attached sample file there is two sheet, sheet1, and sheet3. In sheet1 column A some data is present. If the value in column B is 1 then the value of column A copied to column C and the data in column C are grouped in column D. this part is working very nice.
There is another part, If the value in column B is 1 then the value of column A copied to column A of sheet3 and grouped in column B. This time grouping is not always updated. Double click the column B and pressing Enter can make it work.
And the 2nd problem is some time column D of sheet1 and column B of sheet 3 becomes blank when it must show some value.
In the attached sample file there is two sheet, sheet1, and sheet3. In sheet1 column A some data is present. If the value in column B is 1 then the value of column A copied to column C and the data in column C are grouped in column D. this part is working very nice.
There is another part, If the value in column B is 1 then the value of column A copied to column A of sheet3 and grouped in column B. This time grouping is not always updated. Double click the column B and pressing Enter can make it work.
And the 2nd problem is some time column D of sheet1 and column B of sheet 3 becomes blank when it must show some value.
Attachments

20.4 KB Views: 3