Search results

Thanks, Not sure how write it Sorry Dennis

Hi All,I have a single column with this data -1.2 to 0.7 , I need to create two columns A=-1.2 B=0.7 Any suggestions, would be greatly appreciated Dennis

wow it works, would be able to tell me how does it work? so I can understand it Thanks Dennis

Hi All, How do I convert(if statement) a number like 71 to 71st, 72 to 72nd, and a 73 to 73rd. Thanks Dennis

If I had that situation, I will create a unique identifying number that I could use it with both. Add a new column, and use a filter on information you know and add a unique number each time you filter it, do you follow me? Example ID # Co. name 1 Robert Co 1 Bob's...

If I had that situation, I will create a unique identifying number that I could use it with both. Add a new column, and use a filter on information you know and add a unique number each time you filter it, do you follow me? Example ID # Co. name 1 Robert Co 1 Bob's...

Hui, I do not know what to say other than ""THANK YOU GUYS"" !!! you guys are awesome. if you ever come this way (Chicago)I show you this great city, you have a friend her regards, Dennis

Hello Hui, I try it but I 'am still getting the same error message. Sorry to be a pest Dennis

I'm including a link http://sdrv.ms/TqlCBn Thanks Dennis

Thanks for replying, I still get the same error :(

Hi All, I created a macro but it does not work, attached is the code. What is supposed to do from a master dropdown box is syncronized the other drown down boxes, what it cannot do is deselect the previous selection and select a new value. the eror message reads as follows. run-time...

I found a video that shows step by step on how to Synchronize 2 Pivot Tables with a Combo Box for an earlier version. Here is the link so if it can help somebody else. http://www.datapigtechnologies.com/flashfiles/pivot10.html Regards,, Dennis

Hi Hui, Thanks for your quick reply, assuming I'm able to connect them, the information generated is syncronized to a template and this excel file is going to be send out; so it will be a click annd go situation. Regards,, Dennis

Hi All, How do I go about connecting 5 pivot tables driven by the same unique indicator, the file format is for excel 2007 so slicers could not be used in this case. Any suggestions would be greatly appreciated!! Regards, Dennis

I figured it out my self,, 0.0"%" Sorry Dennis

Hi All, I have 4 columns with whole numbers and decimals( close to 5m each) that I need to convert to a decimal with 2 places. normally I will /100 and that will take care of it, however when there a mix of whole numbers and decimals it becomes a nightmare, is there a function or code that...

Will do, Thanks Dennis

Hello All, A very unusual situation, I have a pivot table filter that sorts in ascending order on Unit name there are about 581 names and the last four are not following protocol. Example: A B c,,,, , w G M H I checked for duplicates names, spaces etc and cannot find anything...

It will be nice having a sample of data, however I used my own data and I came up with this and mine works! =VLOOKUP(I3,Ipad_SY2012_MT.csv!$B$1:$C$14,1,FALSE) once you get the results drag it down please compared to your vlookup below =VLOOKUP(F2,'[File Name.xlsx]Tab...

RAYANK, Thank you so much!! it worked like a charm. I'm glad I found this site. Regards, Dennis

Thank you !!

Thanks I will get back to work on it!! Yes, it should start at row 60. This was my sample copy Do you know anybody that wiil be interested in taking a small project off line? Regards, Dennis

Hi Debraj Roy, I attached a real sample excel file, I have two worksheets, the HS_Data (data source) and the second worksheet (data) which is a combination )a pivot table and template) Once is working I will hide the P Table so you can only see the template. On the Data worksheet, I need to...

Thanks, I will get an example for you Dennis

Here is my if statemet, but not quiet right yet =IF($B4:$B26=$B31:$B86,D4,IF(FALSE,D4="(blank)",NA())) B4:B26 values go from 1 to 26 B31:B86 values go from 1 to 56 What I'm looking for: if the value between B4 to B26 is equal to a matching value between B31 and B86 then use the current...