Search results

Hi All, Hope I can get an answer and a solution, I have a pivot table that synchronizes with a report based on selection from the pivot table. There are 1600 rows of data and each row has a unique id which is always from 1-56. Some selections do not have all 1-56 rows of data (1, 3, 5-56)...

Thanks!!

Hi All, I have two worksheets, worksheet# 1 is the data source about 6000 rows of data,it has a location ID and Unit ID(primary key) worksheet# 2 is a summary report with 56 rows of data and each row has a location ID.(row data to be populated on the correct row in the summary report) What...

Hi All, One last question about conditonal formatting, if I want to hide all #N/A as white can I use #FFFFFF, if so where will I place it? =IF(Ptable!A2="(Blank)",NA(),Ptable!A2) Thanks, Dennis

Hui, You are 'da man' it worked beautiful. I'm so happy that I found this site and you guys were terrific. Thanks for your support and keep up the great work you are doing!! Regards,, Dennis

here is a link to a file for you to review it Thanks, Dennis http://sdrv.ms/QqneNQ

Hi Hui, Your code works as long a cell is empty, but the cells I'm working with have the actual text '(blank)' and using the code just duplicates the cell, this came from a pivot table and that's the need to convert it to #N/A. Thanks for your support Dennis

Great to hear from you guys, is there a way to attached a file? This is what I get on my side Input A B C (blank) (blank) 10.2 output below (blank) (blank) 10.2 ' should be #N/A' Formula =IF(A2="",NA(),A2) I think I see why it does not work on my side!!! the text 'Blank' is...

Thanks for your quick reply, and happy to be here. I inserted your code but the output is the same. Please allow me to explain it. My data A= (blank) B= (blank) C= 10.2 when I refence these cell using the code, I get A=(blank) B=(Blank) C= 10.2 What I need to happen is A= #N/A...

Thanks for your quick reply, and happy to be here. I inserted your code but the output is the same. Please allow me to explain it. My data A= (blank) B= (blank) C= 10.2 when I refence these cell using the code, I get A=(blank) B=(Blank) C= 10.2 What I need to happen is A= #N/A...

Hello All, I'm having a senior moment so I'm requesting for some help, I have a data source with "(blank)" cells that I need to convert them to #N/A using an IF statement but only where a value is not present, if a value exist then it should remain the same sample.The reason is that when...