"Excel 365"

2 Topics

Target file ready for data modelling
Hello, I have a monthly target file which contains, brand wise target and customer wise target. I have file in following order. customer Name Brand total_target january_target february_target ... Customer_A Brand A 100000 5000 Customer_A Brand B 120000 2000 How can I change my target file so that I can model this target to the transaction table thank you!
samrat_devkota
Apr 24, 2023 Place Excel
472Views
1like
0Comments
Unwanted change of the formula when increasing the table
I use the Polish version of Excel 365. I want to cumulatively calculating the data in the table (Table tool) row by row. So I use the formulas: in C2: =COUNTBLANK($B$2:$B2) in C3: =COUNTBLANK($B$2:$B3) e.t.c. When I enlarge a table by one or more rows, the formula in the last "old" row changes automatically to the scope of the entire column. So: - when I enlarge the table to A1:C4, in cell C3 the formula changes to =COUNTBLANK($B$2:$B4) - when I enlarge the table to A1:C5, in cell C3 the formula changes to =COUNTBLANK($B$2:$B5) It looks like Excel's error (365). I have information that the table behaves correctly in XL2007. Greetings Artik (I apologize for my language, but it is as good as Google Translator :-) )
Solved
Artik_K
May 07, 2019 Place Excel
1.4KViews
0likes
3Comments