-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
num#
-
R
How to resolve the #NUM! error in .xlsb file?
Hi, Attached is the excel ".xlsb" formulated file, I am getting error as "#NUM!" in the "Results" sheet from the row 116 onwards. Moreover, I have also enabled iterative calculation box, but still the issue has not been resolved. I would appreciate it if you could help us to resolve the issue...- rajamdade
- Thread
- num error num#
- Replies: 2
- Forum: Excel Questions
-
N
Auto populate numbering sequence
Hi Experts Please can you let me know how to accomplish auto numbering populated ? I can use the formula Concatenate with . =IF(A2<>A1,1,B1+1) but unfortunately the list is not ordered based on ID I am considering. Any help? There are 100s of rows and this needs to be auto populated with...- newexcler
- Thread
- concatenate num# populate cells
- Replies: 6
- Forum: Excel Questions
-
A
remove duplicate rows in excel
Can anyone please help me the way to remove second duplicate rows in excel ? For example: In below need to remove rows with red font. <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Details Num# AAA 62600173 AAAB 62600173 CCC 62600021...- Anirban Majumdar
- Thread
- duplicate excel num# remove rows
- Replies: 7
- Forum: Excel Questions
