Re: Need to reorganize data on a separate sheet possibly using vlookup

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On May 16, 1:38 am, Asa_johannesen
<Asajohanne...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi all you clever Excel people :)

I always seem to have problems setting up anything more complicated than a
simple calculation, so here I go again.

I have one sheet where chick weights are entered according to date (Column A
has dates starting with the date of the first hatch and the following columns
have weights from chick 1 to, say, 100). The chicks hatched on different
dates, so on the first row I have the hatch date, and data are entered from
the first weighing (i.e. lots of columns do not have data in the first few
rows).

Now what I want is a separate sheet, where the data show up according to
chick age. So I want the first column to be age (ranging from day 0, that is
day of hatching, to day 100) and the rest to be weights.

I thought about setting up an IF formula with the dates being used to
calculate the age of the chick and finding the right value (as dictated by
column A in the second sheet) possibly combining with VLOOKUP, but I really
don't know what I'm doing, so it's not really working at all.

Anyone have an idea how I can do this? The idea is that it will be easy to
enter the data in the sheet with a separate date for each row, and easy to
analyse with a separate age of chick for each row on the other sheet.

Thank you, and sorry if I'm asking something really easy that I should be
able to figure out myself. Excel makes me feel stupid sometimes.

I can't quite understand.
Do you mean you want the columns and rows to look exactly the same
except showing "12 days old" instead of "May 4, 2008" in the first
column?
.

Relevant Pages

  • Re: Need to reorganize data on a separate sheet possibly using vlo
    ... has dates starting with the date of the first hatch and the following columns ... have weights from chick 1 to, say, 100). ... So I want the first column to be age (ranging from day 0, ... column A in the second sheet) possibly combining with VLOOKUP, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Need to reorganize data on a separate sheet possibly using vlo
    ... have weights from chick 1 to, say, 100). ... Now what I want is a separate sheet, where the data show up according to ... So I want the first column to be age (ranging from day 0, ... if we have to first check what age the chick was at first weighing (this is ...
    (microsoft.public.excel.worksheet.functions)
  • Need to reorganize data on a separate sheet possibly using vlookup
    ... have weights from chick 1 to, say, 100). ... Now what I want is a separate sheet, where the data show up according to ... So I want the first column to be age (ranging from day 0, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Vietnamese girlfriend - Is she fake ?
    ... chick half his age? ... and thus get chicks half their age. ... 'transferable' but the car is. ... actually, such sex demands risk, it's part of the package, the ...
    (soc.culture.asian.american)