Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Compare Cell Values Between Multiple Columns

  1. #1
    Join Date
    31st May 2007
    Posts
    3

    Compare Cell Values Between Multiple Columns

    I have a workbook with multiple sheets. On the different sheets there are multiple columns of data all set up with a column of dates along side them.

    Something like:

    199901 | 3.5
    199902 | 4.2
    199903 | 6.2
    Etc...

    On the first sheet are statistics that I've incorporated into a macro to automate chart creation. On the second sheet there are 3 sets of columns. The first set has the date in annual format, the second in monthly format, and the third in quarterly format. There is a designation for what the format the date is in on the first worksheet.

    I am looking for a way to search a column (C1:C13 usually) on sheet1 to find a cell containing one of the three formats (Monthly, Quarterly, Annual) and then go to the first numerical value in the column and then go through the corresponding column on the second sheet and find that value to start a chart range.

    If anyone can help with this I'd be very grateful, I can't seem to find an example that does this, and when I try to combine code I've seen elsewhere I don't get the results I'm looking for.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    9th June 2006
    Location
    The best city, in the best state, in the best country, in the known inhabited universe, Houston, TX
    Posts
    966

    Re: Compare Cell Values Between Multiple Columns

    grimnir,

    I bet that makes perfect sense to you but, I can't quite get it. Can you send a sample sheet that has the expected results? It sounds like you want to identify the data range for a chart based on what format a cell uses. I'm guessing there's a better way to do it though so post a sample please.

    Jim

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    31st May 2007
    Posts
    3

    Re: Compare Cell Values Between Multiple Columns

    Attached a fragment of the workbook.

    Included the formatting (the stats are exported using a database add-in).

    1 column on first sheet

    3 columns on second sheet

    First sheet: in cell C11 it defines the date format as being quarterly. This definition will not always be in the same place (I don't have control of its placement in all conditions).

    In this case the dates on the second sheet match those on the first. But in reality there will be dates from the 1940s to the present on one or both sheets. I need to find a way to match the correct starting date from B13 on sheet 1 to the matching date in the correct format column on the second page. ( I need to do this so that I can apply a recession bar to a line graph made from the figures on the first chart.)

    Hope this helps make it clear, couldn't think of any better way to describe the problem. I could just be over analyzing it though, its been known to happen.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    9th June 2006
    Location
    The best city, in the best state, in the best country, in the known inhabited universe, Houston, TX
    Posts
    966

    Re: Compare Cell Values Between Multiple Columns

    grimnir,

    I'm still a little fuzzy but, here's a couple of thoughts anyway.

    The frequency (.FRQ) can be searched in a vlookup formula on the first sheet and the word two columns to the right can be returned like so:
    =VLOOKUP(".FRQ",Sheet1!$A$1:$C$100,3,FALSE)

    The result of this formula will tell you whether to look in the Quarterly place the Yearly place or the Monthly place. You can specify the places with a range name and that gets you the ability to refer to the place by finding the word ".FRQ" on the first sheet.

    Does that help?

    Jim

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 5
    Last Post: June 21st, 2012, 16:50
  2. Compare 2 Columns & Place Unique Values In a 3rd
    By April82 in forum EXCEL HELP
    Replies: 4
    Last Post: February 13th, 2008, 09:55
  3. Compare 2 Columns To Find Unmatched Values
    By oceanspray in forum EXCEL HELP
    Replies: 2
    Last Post: October 26th, 2007, 13:08
  4. Compare Values In 2 Columns To Another
    By magnus75 in forum EXCEL HELP
    Replies: 12
    Last Post: December 5th, 2006, 18:36
  5. compare values in two columns
    By krishna in forum EXCEL HELP
    Replies: 1
    Last Post: November 26th, 2004, 11:19

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno