Situation: You are part of the Finance Team, and work at Headquarters of an Organization.Periodically, You receive expense data from Teams in different Regions.After You receive expense data, You SUM all...
Q) You apply Data Validation to a range of Cells. e.g. You apply Data Validation Drop-down List of 5 Indian Cities: Indore, Lucknow, Mumbai, New Delhi, Pune, to a range of Cells What if invalid data...
You must have observed when you are typing Month names, Excel suggests the next Month Name. Also, you can drag the cursor using the anchor at the right bottom of cell and the series of month...
Here we are using upper case formula, these formula are used in advanced excel. A B C 1 Hansraj HANSRAJ =upper(TEXT) =UPPER(B1) 2 lakir LAKIR =UPPER(B2) 3 Seema SEEMA =UPPER(B3) 4 Mansi MANSI =UPPER(B4) 5 jyoti JYOTI =UPPER(B5) 6 mahima MAHIMA =UPPER(B6) 7 shashi SHASHI =UPPER(B7) ...
INSTR works similar to FIND function in Excel. INSTR search for specific text in a given text and returns the position number of what you are searching for. Syntax: InStr( , string, searchingfor, ) Sub...