Then for sub type to work you need to write the if function in data validation as =if(G7="Medical",Medical_Sub)
then select medical in G7 and check sub type
Then for sub type to work you need to write the if function in data validation as =if(G7="Medical",Medical_Sub)
then select medical in G7 and check sub type
Last edited by hemesh; 10-21-2013 at 09:56 AM.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks