Hello Guys,
I have excel data for HDD Free space(in 5-6 digit) and want to look which machine with C drive & Free HDD is less than 20GB (20,480MB).
The total free space in 5-6 digit(in MB) and please help the formula to find HDD <=20GB. Thank you.
Hello Guys,
I have excel data for HDD Free space(in 5-6 digit) and want to look which machine with C drive & Free HDD is less than 20GB (20,480MB).
The total free space in 5-6 digit(in MB) and please help the formula to find HDD <=20GB. Thank you.
Last edited by Ferry Wils; 07-23-2020 at 10:55 PM.
You should know by now that you need to manually mock up 10-15 rows of results data - where will I find this in your workbook, please?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Have you tried Advance Filter to filter number that smaller than 20480 in column D or E?
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks