1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Excel formula changing by itself after entering

My excel COUNTIF formula's range keep changing by itself after typing the formula finish, the criteria did not change. I did not drag down, its not an autofill as well, the range I use is referencing from another sheet (i.e SheetB!A:A), it will change to SheetA!A:A which is my current sheet by itself, after I finish typing the formula. Any idea?

submitted by /u/luminostr
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#AI formula generation techniques
#formula generator
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com