Ask Experts Questions for FREE Help !
Ask
    Desiree22's Avatar
    Desiree22 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Aug 28, 2012, 07:57 PM
    How do you use v lookup to trend data
    I need to trend by DOB and Diagnosis (how many people with same DOB and same diagnosids). Im not sure what the best way to do this is? I tried the vlookup but that didn't work. Here's an example of my column headings. My spreadsheet goes to line 371.

    Date Census Day Hospital Inpatient Referrals DOB DX
    8/22/12 14 None 2/2/1892 Cancer
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Aug 29, 2012, 09:41 PM
    You don't use VLOOKUP for anything other than looking up a piece of information in a reference table and bringing back a different piece of data from the matched row. That's what VLOOKUP is for. It's not a statistical function.

    You could read up in Excel's help files on TREND if that is truly what you want. It may not be.

    Perhaps you should look at COUNTIFS() function, or try a PivotTable.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

I see a trend here about 401ks [ 3 Answers ]

Anyone notice it? Look how many posts are about people wanting to take money from their retirement years account! (for one of many reasons) :confused: :eek: Why? Is living in America that expensive that everyone is broke? Or is it something else.. People overspending, over...

Forward lookup,reverse lookup [ 1 Answers ]

Hi I am not getting the idea what exactly is FORWARD LOOKUP, REVERSE LOOKUP,zones while configuring DNS . Can anone explain briefly or give me the link to go through:)

View more questions Search