We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide

Excel 07 Query

former_student
former_student Posts: 509 Forumite
in Techie Stuff
Hi All,

I have a database setup on a tab within Excel 07, is it possible to manipulate the information within this tab on a separate tab within Excel?

For exampe, I have column with a list of week numbers on it (Column A) and a column with a list of participants (Column B), is it possible to on tab 2 to ascertain how many participants there were for a particular week and if so how is this done?

Thanks in advance.

Comments

  • skivenov
    skivenov Posts: 2,204 Forumite
    Yeah, just type the formula in as you normally would, then when you get the point of needing data from another sheet, click that tab and the relevant cell(s).
    Yes it's overwhelming, but what else can we do?
    Get jobs in offices and wake up for the morning commute?
  • akamustang
    akamustang Posts: 59 Forumite
    =Sheet1!A1
    MFiT-T3 :: Reduce mortgage to 80k (86.30%)
  • HeadAboveWater
    HeadAboveWater Posts: 3,941 Forumite
    Part of the Furniture 1,000 Posts Combo Breaker Debt-free and Proud!
    Formula being along the lines of "=COUNTA(Sheet1!B1:B7)" if it's data in the cells rather than numbers.
    Wealth is what you're left with when all your money runs out
  • johnmc
    johnmc Posts: 1,265 Forumite
    edited 8 October 2012 at 6:46PM
    If the data is in sheet1 and the counter is in sheet2.

    List the weeks as numbers, Highlight the column and select FormatCells > Custom and in the Type box put ("Wk " 00) without the brackets.

    Use COUNTIF to get the numbers.

    =COUNTIF(sheet1! << range of weeks >>,sheet2!a1)
  • alidai
    alidai Posts: 587 Forumite
    Part of the Furniture 500 Posts Combo Breaker Name Dropper
    Simple answer - click Insert Pivot Table, you will then be able to manipulate the data to your hearts desire
  • johnmc
    johnmc Posts: 1,265 Forumite
    Pivot tables are not dynamic.

    Add to the data and it doesn't update.

    Easier and better to learn how to do it with equations.
This discussion has been closed.
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 353.5K Banking & Borrowing
  • 254.1K Reduce Debt & Boost Income
  • 455K Spending & Discounts
  • 246.6K Work, Benefits & Business
  • 602.9K Mortgages, Homes & Bills
  • 178.1K Life & Family
  • 260.6K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16K Discuss & Feedback
  • 37.7K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.
Update Your Picture