Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Extracting Data in Excel


  • Please log in to reply

#1
swicklund

swicklund

    Member

  • Member
  • PipPip
  • 25 posts
I have a list of data on an excel worksheet, and would like to extract all data for a given state on another worksheet. Data keeps getting added to the first worksheet, and would rather not have to sort, copy, and paste everytime I want to do an analysis.

Is there a simpler way to do this?

Thanks,
  • 0

Advertisements


#2
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP
data for a given state as in...state in the union? (ie texas florrida ohio) or state is in data from a specific state of the file?
  • 0

#3
swicklund

swicklund

    Member

  • Topic Starter
  • Member
  • PipPip
  • 25 posts
State of the union (MN, MI, WI, etc....)
  • 0

#4
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP
i don't remember the full syntax in exell but you'll want to use an if statement there...it would end up being (logically) if this collumn(first page) is TN then this collumn(second page) is the data for tn on the first page...some kind of horse hockey like that...
  • 0

#5
swicklund

swicklund

    Member

  • Topic Starter
  • Member
  • PipPip
  • 25 posts
I was afraid it would be something like that. I was hoping there would be a quicker method.

Thanks,
  • 0

#6
warriorscot

warriorscot

    Member 5k

  • Retired Staff
  • 8,889 posts
Have you tried using a database instead if its being used that regularly, they are harder to set up to begin with or at least they can be but it might be worth you looking into if you use it everyday.
  • 0

#7
swicklund

swicklund

    Member

  • Topic Starter
  • Member
  • PipPip
  • 25 posts
warriorscot,

Yes I have, and that is the way that I would do it. I have a friend taking an Excel class, that asked me for help. I was trying to help her go above and beyond.

Thanks,
  • 0

#8
warriorscot

warriorscot

    Member 5k

  • Retired Staff
  • 8,889 posts
Ah right i see, yeah excel has alot of bells and whistles but sometimes you have to bite the bullet and switch to the more appropriate software.

I think youre stuck with either the conditional statement formula, or writing a macro for it.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP