**[Solved] VBA to Stack The Data in Two Columns** *Summary*: I have 300+ rows of data in each of columns A and B and I would like to stack them, starting from row 3. As an example I would like this:
A ...

**Need formula to calculate duration between 2 dates.** *Summary*: Need formula to calculate duration between 2 dates in separate columns. For example: start date 10/20/2010 end date 4/13/2011. Need result in month...

**[Solved] Find out condition value and format by Comparing Two Columns** *Summary*: I am trying to compare two columns in Excel. not cell to cell. Eg: A B 1 1 2 1 3 3 4 4 5 3 6 5 2 1 5 2 5 ...

**I am trying to compare two columns in Excel.** *Summary*: I am trying to compare two columns in Excel. Eg: A B 1 1 2 1 3 3 4 4 5 3 6 5 2 1 5 2 5 5 4 3 I ...

**[Solved] Excel Formula to count # Month-Year entries in a column** *Summary*: In a number of columns of my spead sheet I have Date columns with the format e.g. 12-Dec-12. I need to count the number of times Dec-12 shows up in t...

**[Solved] If AND Statement to Check in two Columns** *Summary*: If I have Y in A1 and Blank in B1 then Blank in A2 and Y in B2 How do I check with IF AND statement if there is a Y in either column and if there is ...

**[Solved] Check to see if an email address is on the database** *Summary*: Tried everything please help In column A I have a list of 1500 email address's In column F & G I have another 1500 email address's in the two columns...

**[Solved] Comparing two columns in Excel.** *Summary*: Want to compare two columns and determine one of three things- was there an increase, a decrease or no change with the results able to be "conditional...

**[Solved] hide and sort columns and rows macro** *Summary*: hi, I have a 3 columns: 1st column is the type and the next 2 columns are percent and rate. I want to automatically sort the data descending according...

**Align multiple columns to 1** *Summary*: Hi, I need columns B (item#) & C (item description) to stay together to match by column B (item#) to A (complete list of item#s). How can this macro...

**move part of a row over to a different column if...** *Summary*: I need to move part of a row over to a different set of columns depending on what year the first cell starts with. Therefore, I would have all of one ...

**IF then statement for color corresponding to date** *Summary*: I am creating a tracker that has todays date in Row one corresponding to the days of the month in Row2 All the columns beneath contain an X. I would l...

**[Solved] Text to Columns based on Uppercase** *Summary*: If I have data that needs to be separated into columns that looks like this: JaneDoe MaryannSmith RobertWhite Is there a way to separate into a first ...

**Advanced Excel Question on Columns** *Summary*: I am tasked with Copying an old paper form to excel. It is being asked to look "exactly" the same. It was obviously made with word, because all the co...

**[Solved] Align columns by rows with identical values** *Summary*: Apologies if this doesn't format correctly, not sure what the < PRE > tag does :\ I've read this - http://www.computing.net/howtos/sho... - but I d...

**[Solved] copying sets of data in xcel from one spreadsheet to another** *Summary*: How can I copy groups of data from one spreadsheet to another when the cells are split up? Is there a way to ensure that data from certain columns are...

**Setting up columns for translations, English & German** *Summary*: I am working with columns. I want to type the English in the LEFT column and the translation (German, Spanish, etc) in the right column. I want to b...

**[Solved] putting columnar excel data into rows** *Summary*: My data to convert from rows to columns is like this: Person A - Data1 Data2 Data3 Person ...

**[Solved] Need formula to calculate time difference between 2 columns** *Summary*: I have a column with the hrs:min for start and another column with the hrs:min of end of an activity. it happens within same day. Hrs are 0-24 and mi...

**[Solved] Date comparsion in excel** *Summary*: Hi All I have 2 columns of date where i need to compare the date and if it matchs or less than that date i should give the answer as MET if not it sho...

**Selecting multiple columns with wildcards ..** *Summary*: I have a table TABLE_A on Oracle and it has multiple columns beginning with X. For ex. Xxaa, xxyyy, aax etc. Now I want to select fields, which begin ...

**[Solved] need to convert 1 column of address data to multiple columns** *Summary*: I have an address list in col A in excel with a blank row between each address I need to put them in up to 9 columns name address1 address 2 et...

**[Solved] Sort & Match one column of data with columns of data** *Summary*: Match data in spreadsheet by sorting. Have a spreadsheet I need to import into accounting program. Amazon uses ASIN numbers and everyone else uses ISB...

**Concerting the #Value! to zero 0 or hyphen (-)** *Summary*: I have columns which cannot calculate and they are giving me the output #VALUE! in excel as shown below, for some it calculates. 11.05 57,000.00 #...

**[Solved] Compare values between columns** *Summary*: Hi, I am trying to run a COUNTIFS formula that compares values in column B to column A. I want to count the rows, if in B the values therein are >= th...

**[Solved] Excel Spread sheet tranferring selected rows** *Summary*: Hello everyone, really in need of some help!!! I have only ever used the basics on excel, spreadsheets and formulae. Ive been issued the task of track...

**[Solved] merge files in column output** *Summary*: Hi all, I am trying to merge txt files (from which first column is equal in all) into one file: 1.txt 2.txt 3.txt l1 a1 l1 b1 l1 c1 l2 a2 l2 b2 ...

**[Solved] Excell column addition** *Summary*: Hi, I want to set a formula by which every cell of a particular column will be the sum of values of some previous columns of the corresponding columns...

**fix first and last column in excel** *Summary*: I'm trying to make a chart to track the workouts of a group of people over the course of the summer. I want the first column and the last column to...

**Need to Copy Columns in Tab Delim Text File** *Summary*: I have a tab delimited text file that I need to be able to copy specific columns from and then paste them into a new tab delimited text file in a cert...