I have a large table of data and I want conditional formatting to highlight an item if it contains a specific part of a text. For example part number is Z10105 but there are 1,000 of parts that begin with that series Z10105MJB, Z10105QZR,...etc, etc and I want a flag of highlighting it if it...
I got this formula somewhere and it works fine on 1 file. I just tried to add it to another file and it returns #NAME? error. Now I can't find anything on this formula.
Regards,
~Dee
I am trying to write an If statement that looks at a cell that has a calculated formula in it but if the answer is 0 for it to return a blank but if it is not 0 I want it to compare the results with the calculation in another cell on another worksheet (Cell=calculated average cycle time) and...
How can I get the pivot table to count the number of the results of a formula instead of counting the number of formulas in a column of cells? When I created a pivot table it gives me a total count of cells that contain a formula instead of the total number from the formula which is a text.
The...
I am trying to have a cell look at another cell with a date in them (i.e. 12/15/2011) and return only the 3 letter Month but only if there is a date in the cell. I tried the below formula which doesn't work:
=IF(C5>1,=TEXT(DATE(YEAR(C5), MONTH(C5), DAY(C5))," MMM")," ")
If I just do the...
How can I get the average of the results of a formula and have it update with every entry?
I have a column that calculates the cycle days between when I receive a report request and when I complete it. The formula is =NETWORKDAYS(M29,O29,) I want to calculate on a summary page what my average...
Hello, I have been using Excel for quite sometime but am new to the VBA side of it. :) I am trying to create a Macro using VBA and The 1st Macro I created using just record works fine. When I tried to create a 2nd Macro in the same worksheet but using VBA instead of record and I assign it a...
I seen several post on timestamps but none seem to just show a timestamp that stamps at the time a cell is populated and remains that time. I would like a formula that makes a simple regular timestamp that works like a regular timestamp meaning it stamps it with the time that the action is taken...
How would I do a sumif function with index match. I have several sheets of data and I want the results to appear on a main table. See example below:
Item number Quantity
Each sheet has an item number with a quantity. Each sheet represents a location. Each location has several items some...
I need to highlight cells in one column when two cells in separate columns match in Excel 2003. I tried doing a conditional formatting formula is: =match($A1,$B1,0) while in the cell I want highlighted when that condition is true. & Excel gives me an error saying not enough arguements.
Everytime I try to hide a bunch of rows on this one spreadsheet I keep getting an error saying "Cannot shift objects off sheet." I can't figure out why. Can anyone help me with this? I have never seen this error before when just simply trying to hide multiple rows.
Thank you,
Dee