Excel Magic Tricks
Share
Its about to solve the Microsoft Excel related problem very easily. Excel Magic Trick
Magic!
Ctrl + H
Time Group Formula in Excel.
=TEXT(D2,"h AM/PM") & " to " & TEXT(D2+1/24,"h AM/PM")
Time Group Formula in Excel.
=TEXT(D2,"h AM/PM") & " to " & TEXT(D2+1/24,"h AM/PM")
Time Group:
7 AM – 8 AM
8 AM – 9 AM
9 AM – 10 AM
How to solve an extremely large number?
QUERY in G Sheet
=QUERY(Main_data!A:D,"SELECT A,B,C,D WHERE D='COMPLETE'",1)
=QUERY(Main_data!A:D,"SELECT A,B,C,D WHERE D='INCOMPLETE'",1)
=QUERY(Main_data!A:D,"SELECT A,B,C,D WHERE D='CANCELLED'",1)
Upgrade from VLOOKUP in Excel to INDEX MATCH for greater power and flexibility.
Click here to claim your Sponsored Listing.
Category
Contact the school
Telephone
Website
Address
Dhaka
1217
