## Columns Related Problems & Solutions

32 tags
Refine Tags
Search Tags:

Results 1 - 30 of 32
[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 ...

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 ...