Search results

I am so sorry it seems the problem was that there were no blank rows in the table so I filtered out only N/A & that worked. Thank you all for all your help! & patience. It is greatly appreciated!!!

Yes I want to filter out N/A 's & blank rows. Only want rows over that have a date value in it. Chat AI suggested =FILTER(MainTable,ISNUMBER(DateValue(MainTable[D/O]))) But that gives me a #Calc! Error. So there must be something in the table messing it up.

No there is no space it is blank. I want to bring over only those cells that contain a date in them.

Oh yea sorry I forgot to put the 1st maintable on here but it is in my formula but I tried the >" " that part works but it is still bringing over the "N/A" 's not sure why.

The columns does gave blanks.

Why would this formula not work: =FILTER(MainTable[D/O]<>"N/A")+(MainTable[D/O]<>" ")) Table is named MainTable Column header is D/O It returns the whole table with all the typed in N/A's not the error N/A just a typed value N/A? Regards, Dorothy A

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...

Thank you. You were right. :)

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...

I tried to figure out how you added month and year to the pivot fields but I haven't been able to figure it out. How did you separate them out?

Wow you are awesome! Thank you :)

That is awesome but I also needed it divided across the top where it says FMQR by month I also need it by Type so horizontal access is by type and vertical like you have it by month. :)

See attached. :)

Okay it let me this time see attached

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...

Oh okay thank you :)

Thank you that worked :)

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...

@ Luke M I know it has been a year and I am not sure what happened with my project lol but how do I pull data from several sheets into a single pivot table? ~Dee

Thank you both for your input. I only have the one workbook open but the short cut key is still now working. @small man I didn't know where to cut the workbook name from? Thank you again for trying to help. :) ~Dee :)

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...

oh I was hoping there was a way to do a match or index match formula so I wouldn't have to do all that copying and pasting data into a conglomerated page from about 10 pages of data.