Closed Thread
Results 1 to 2 of 2

If value matches any other in column make calculation, Algorithmic Calculation

  1. #1
    Registered User
    Join Date
    09-24-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    3

    If value matches any other in column make calculation, Algorithmic Calculation

    Ident time alt lat lon
    a334 0.33 2000 45 51
    a336 0.33 2500 44 50
    a788 0.33 5000 44 25
    a521 0.33 1000 49 10
    a852 0.4 2000 45 3
    a956 0.5 100 20 30
    a841 0.55 8000 20 63
    a965 0.6 8000 24 65


    I need a formula that recognizes identical times then takes the difference between the altitude, lat, long of the two identical times.

    So ideally the calculation that would be performed.

    Ident (a334)-(a336) 2000-2500 45-44 51-50
    Ident (a334)-(a788) 2000-5000 45-44 51-25
    Ident (a334)-(a521) 2000-1000 ''''''' ''''''''''
    Ident (a336)-(a788) 2500-5000 '''''' '' ''''
    Ident (a336)-(a521) 2500-1000
    Ident (a788)-(a521) 5000-1000

    I created a pivot table to try to calculate the difference but it cannot do it an a algorithmic type fashion like this. Then eventually I need to conditionally format it to if all three meet a certain criteria that it will put it in a separate chart only if all three conditions are met.

    So if Ident (a334)-(a336) 500 1 1 (ex. of all three criteria being met [actual parameters not important but these values will be flagged in my conditional formatting])

    This needs to then be put in a separate chart with all other data that meets all three criteria.

    So the steps I need to perform this function:

    1. Does Ident "x" equal Ident "y" time?

    Yes: Take difference between all three parameters. Do all three meet Criteria?

    Yes: Put all calculated info in separate chart if they meet all three criteria. Does Ident "x" time equal Ident "z" time?

    Yes: Take difference between all three parameters. Do all three meet Criteria?

    No: End

    Yes: Put all calculated info in separate chart if they meet all three criteria. Does Ident "x" time equal Ident "aa" time?

    No: End

    No: End

    No: Move on to does Ident "y" time equal Ident "z" time?

    [Rinse, Wash, Repeat]Generic Algorithim.xlsx

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: If value matches any other in column make calculation, Algorithmic Calculation

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 09-24-2013, 02:06 AM
  2. Replies: 1
    Last Post: 01-15-2013, 08:51 AM
  3. Replies: 4
    Last Post: 04-04-2011, 10:10 AM
  4. do a calculation if a date range matches
    By kistev in forum Excel General
    Replies: 3
    Last Post: 04-05-2007, 12:39 AM
  5. Replies: 2
    Last Post: 04-14-2005, 01:06 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1