Functions

Create new records from existing ones based on 'rule'?
I am trying to pull apart records I uploaded that are set up something like this; MainField | Other Fields | AssociatedFIeld1 | AssociatedFieldN There can be anywhere from zero to 6 Associated Fields. Trying to break a new record apart for each e.g. MainRecordX | Other Fields | WidgetA | WidgetB MainRecor... 28 May 2010 10:27

Concatenate with a specific number of spaces
Hi all I would like to do this in excel and wonder if its possible In cell a1 i have 1234 in b2 i have an address in c3 i have 600.00 and in d4 i have 1 I have to have them concatenated but also i need 5 spaces after the first cell, 4 spaces after the second and 6 spaces after the third when concatenated... 28 May 2010 10:27

Linking text cells between 2 worksheets
I tried this before but explained my problem so badly I did not get the response I was looking for, so let me try again. My workbook contains sheet 1(the source sheet,) and sheet 2 (the destination sheet.) I am entering text into a column of cells in the source sheet, and would like it to be entered into the de... 27 May 2010 18:11

frustrated excel newbie
I am trying to make a monthly worksheet. I did get a drop down box set up, typed 6/1/2010 through 6/31/2010 in an empty column, used the validation tab, chose list and highlited the dates column which showed up as a formula in the validation window under my "list: choice. problem is, when I click on one of the ... 27 May 2010 18:11

Concatenate with a specific number of spaces
Works like a charm, thanks Tim "tim m" wrote: This should work though I'm not sure if it is the most efficient way. Create a new column in the column enter this formula =A1&" "&B2&" "&C3&" "&D4 (Put the proper number of blanks spaces inbetween the " ") That should give... 27 May 2010 18:11

SumProduct Between Dates
Having a tough time with this one. Sheet 1 Column A = Start Date, Column B = End Date, Column C = Quantity. Sheet 2 Row A = Start Date, Row B = End Date. I would like Row C to sum quantity from sheet 1 where ever the two date ranges intersect. The date ranges on sheet 2 represent the beginning and ending of... 28 May 2010 10:27

Two Level Search
I have simplified the example ----- I would like to search the table shown below and determine the amount Pledge by each family. However since there are last names that are the same, a simple vlookup does not work. For example, I must define my search so I get Bill Johnson, not Frank Johnson. For the example... 28 May 2010 10:27

Macro to build table
I have 6 questions that may be answered yes or no, and for the sake of keeping everything in integer form, let's assume "1" for yes and "0" for no. Depending on how a customer answers all 6 questions, they will receive a predetermined score. I am attempting to develop the answer key, so-to-speak, to refer the ... 27 May 2010 18:11

frustrated excel newbie
hi format the cell with the validation to date. if formated as general, you will get the serial date number. Regards FSt1 "TJ" wrote: I am trying to make a monthly worksheet. I did get a drop down box set up, typed 6/1/2010 through 6/31/2010 in an empty column, used the validation tab, chose list... 28 May 2010 10:27

Macro to select last row
I am trying to automate putting a sheet value into Row I. My manual method is to paste the formula in I2 (since values begin on Row 2), then go to A2, Ctrl Down until I hit the last record (there are cases where there are blanks so sometimes I need to do this a few times) and when I reach it tab back over to t... 27 May 2010 20:23