Hi all, i have a large database of Equipment annual Schedule. I want to compare equipment's current status with the desired status as per the schedule when i select the date. and also display " No action" if matching else Display" Changeover" if not matching. I tried using index and match...
Hi everyone,
i am bit new to excel, i am struggling to find a formula for my task. I am in process industry, and we have equipment change over schedule. on every Friday we have to check all equipment for their desired condition from actual condition and take action accordingly.
in short, if it...
Dear all,
i have prepared 8 teams for a tournament consisting of 15 members each team.
I have placed them in a a order, best player at the top to weakest at no 15. I want to apply different color to each team and apply gradient fill to each team. From best player to weakest player. I tried...
Hi friends,
I am looking for any downloadable cell styles/ themes . I tried making my own , but not happy with the results. When i see some made by others , i wonder how they made it.Especially the colour combinations and effects. I checked downloads section, there are many templates and...
Dear all,
i have shift calender excel file, which i want to enlarge it and print on four A3 size sheets and stick together. i tried in different ways but failed. Now i have printed in one A3 size paper ,i want this to past it on meeting room, as one A3 size print out still looks small in...
Dear friends
i have a database of members with lots of details which is being maintained over 5 years now. couple of years ago, the phone numbers have changed from 7 digit to 8 digits. We have different series of phone numbers starting from 3, 4 5, 6 series. I need to add additional...