Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
I have an Excel spreadsheet that has 40 rows and several columns which includes "Legend", "HRS", and "$" as column headers and there are eight categories to select from a drop down menu in "Legend".
As an example, I need to identify all individual "Legend" categories, i.e., VAC, which could be in one or more than one row, not necessarily in consecutive order, and then total the corresponding "HRS" and "$" for VAC.
I have tried IF/AND but was not able to get it correct.
Summary: I just copyied a range of cells (A10:G90) in Excel...and PASTE SPECIAL > VALUES into another area (A100:G190)... There are a total of 7 columns and 80 rows... In the range that I copied them to, the f...
Summary: I have a column of numbers in excel 2003, but it won't recognize them as such--the report in excel was generated from another app. Is there any way to tell excel to recognize the numbers as numbers so...
Summary: Delete it or make it so it shows no value such as " " (a blank space). If a blank space is acceptable then you can use an IF formula. Let's say your data is in column A starting in Cell 1. In B1 use =...
0 
