Hi,Most of us know that using Vlookup function we can get the right column values, however by using Choose function in Vlookup table array, we can pull left column values as well. In the below screenshot...
Many people struggle to find out the way on how they can work faster while working on MS Excel/Access or VBA. let me share the tip for that. If you are new or working since long time on Excel/Access...
From an organizational point of view, e-learning courses can be conducted by trainers in one location and it can benefit employees across continents in different time zones. This can bring down training...
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) ...