General

Copy to filtered blank rows from another spreadsheet
Hi, I have a spreadsheet that it's filtered to show blanks items in column J, I want to copy into this column J data from another spreadsheet's Column J. is there an easy way to do? Basically, need to copy from spreadsheet 2 column J into the filtered blank rows in Spreadsheet 1 column J . Any help would b... 28 Apr 2010 15:11

VLookup to bring in not true data.
Hi, I need to create an if statement or vlookup that will compare both columns and bring back the results that is not true. I know what matches so basically I want to see all the data that doesn't match. I want to see the results of everything in Account II that doesn't match Account. Help everything I tr... 29 Apr 2010 02:25

Text to Columns Help
Can someone show me how to convert a column of data filled with information like this: 2.756.00-9,86259,172.00-45,953275,718.00 to 6 columns like this: 2.75 6.00 -9,862 59,172.00 -45,953 275,728.00 ... 28 Apr 2010 16:20

Pallets w/varying sizes & weights need to fit in restricted space
I need to configure pallets of varying sizes & weight into a container. The Containers are 53 by 8 feet long and can carry approximately 45,000 lbs. Below is the pallets that need to be put into containers. I need something that will return the best breakdown of what to put in a container; container 1, 2, 3 ... 28 Apr 2010 15:11

Structured references between worksheets
Can you use structured references between worksheets? I have 2 excel tables in separate worksheets. One table needs to reference data in column in another worksheet. Everytime I put in = in cell of table 1 and go to table 2 (on tther sheet) I get the usual 'SHeetname'! How can I replace this with Table name and... 28 Apr 2010 15:11

CANNOT SHIFT OBJECTS IN SHEET
hi, I have been able to work around problem in past. where I have many columns: thru IL (of IV) 10 cols left. I have been able to insert columns with as little as 5 cols left. 1 trick I used was to increase the column width of the empty columns to the right. this seemed to allow space for adding/ insertin... 28 Apr 2010 15:11

pop up calender PT 2
Thanks Jim This is what I needed but I am having a problem connect the date to a cell that will work with the VLOOKUP attached Can this date be tied to the cell? You can try the Microsoft Date and Time Picker control. Add the Control Toolbox menu to your toolbars. Select the last button that looks like ... 28 Apr 2010 15:11

Help!!!!!!
Pls pls pls take time to read this: I need to link the values in two separate sheets of the same file. The data that i enter in sheet 1must appear in sheet 2 as follows. the values i enter in A1 must come in A1 A2 must come in A6 A3 must come in A11 A4 must come in A16. the values are to appear in the second... 28 Apr 2010 15:11

Calculation of Age
How can I calculate "age" from columns of dates rather than individual rows(single case) either using the following functions COUNTIF, YEARFRAC, DATEDIF or YEAR ... 28 Apr 2010 15:11

Round Date & Time
I have a Start Date in Column A and Start Time in Column B. I know how to add them togehter, but how do I add them together and round to the nearest hour. Example Col A Col B 4/28/2010 5:23 PM Results should be 4/28/2010 5:00 PM ... 28 Apr 2010 15:11