Results 1 to 8 of 8

Compare Values in Multiple Columns and return a result

Threaded View

edbhome Compare Values in Multiple... 03-17-2009, 04:13 PM
NBVC Re: Compare Values in... 03-18-2009, 08:40 AM
edbhome Re: Compare Values in... 03-18-2009, 09:05 AM
NBVC Re: Compare Values in... 03-18-2009, 09:13 AM
edbhome Re: Compare Values in... 03-18-2009, 09:18 AM
NBVC Re: Compare Values in... 03-18-2009, 09:25 AM
edbhome Re: Compare Values in... 03-18-2009, 09:28 AM
NBVC Re: Compare Values in... 03-18-2009, 09:37 AM
  1. #1
    Registered User
    Join Date
    09-19-2008
    Location
    maryland
    Posts
    23

    Compare Values in Multiple Columns and return a result

    I have a spreadsheet with three years worth of data for a property I manage. Each column has cost data for the year and the specific department/cost for that year as the row value.

    I have a column between the years that calculates the percent of gross revenue for the specific department/cost.

    I would like to find (or create) a formula that will compare the percentage (or specific cost) for the three years within the specific row and if the increase year over year over year exceeds a trigger value it returns something (check me out/true/false) whatever.

    The cost items for the property are in the hundreds so I'm trying to come up with a way to quickly see what specific cost items are going up (or down) more rapidly then what would be considered normal.

    Any help would be appreciated.

    Thanks in advance,

    Ed
    Last edited by edbhome; 03-18-2009 at 09:29 AM.

Thread Information

Users Browsing this Thread

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

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