I have inherited a spreadsheet from a previous worker (who, of course, is no
longer here), and I've spent too many hours trying to figure it out on my
own. I need to make adjustments to the spreadsheet, but don't even know
where to begin because I don't understand the formulas. I'll try to explain
briefly...

There are several worksheets to include some named "FINAL", "DATA" and
"PRINTOUT". Most of the formulas are in the PRINTOUT worksheet. The FINAL
worksheet is simply where data gets dumped from a database (in a particular
order). I just found the DATA worksheet (it was hidden), and it has column
headers without any spaces, and all the other cells in DATA have the
following formula: =TRIM(FINAL!A2)
(replace A2 with whatever the actual cell number is for the entire
worksheet). Also, I noticed that the print area for the DATA worksheet is
huge, but I don't know why...goes down to row 1745 and over to column AX. We
would definitely use the columns with our data, but never down to row 1745.

The PRINTOUT worksheet it where it all happens...I think. There are several
formulas, but they all look very similar. They all return a value from the
FINAL worksheet. Here are some examples of the formulas:
Note - "TITO" refers to a Name of "=DATA!$1:$101"
=IF(INDEX(TITO,$A4+1,C7=0,"",INDEX(TITO,$A4+1,C7)
=IF(INDEX(TITO,$A5+1,C8)=0,"",INDEX(TITO,$A5+1,C8)
=IF(INDEX(TITO,$A14+1,C14=0,"",INDEX(TITO,$A14+1,C 14)

I've been reading about INDEX arrays because I think that's what this is,
but it's just not making any sense to me. Is there someone that could help
me decipher this spreadsheet so I can make the needed changes? Pretty please?

Thanks,
Kim

It looks like it's just checking to see if a cell is empty, and if so it puts
a 0 instead of nothing.

"Kim Nacrelli" wrote:

I have inherited a spreadsheet from a previous worker (who, of course, is no
longer here), and I've spent too many hours trying to figure it out on my
own. I need to make adjustments to the spreadsheet, but don't even know
where to begin because I don't understand the formulas. I'll try to explain
briefly...

There are several worksheets to include some named "FINAL", "DATA" and
"PRINTOUT". Most of the formulas are in the PRINTOUT worksheet. The FINAL
worksheet is simply where data gets dumped from a database (in a particular
order). I just found the DATA worksheet (it was hidden), and it has column
headers without any spaces, and all the other cells in DATA have the
following formula: =TRIM(FINAL!A2)
(replace A2 with whatever the actual cell number is for the entire
worksheet). Also, I noticed that the print area for the DATA worksheet is
huge, but I don't know why...goes down to row 1745 and over to column AX. We
would definitely use the columns with our data, but never down to row 1745.

The PRINTOUT worksheet it where it all happens...I think. There are several
formulas, but they all look very similar. They all return a value from the
FINAL worksheet. Here are some examples of the formulas:
Note - "TITO" refers to a Name of "=DATA!$1:$101"
=IF(INDEX(TITO,$A4+1,C7=0,"",INDEX(TITO,$A4+1,C7)
=IF(INDEX(TITO,$A5+1,C8)=0,"",INDEX(TITO,$A5+1,C8)
=IF(INDEX(TITO,$A14+1,C14=0,"",INDEX(TITO,$A14+1,C 14)

I've been reading about INDEX arrays because I think that's what this is,
but it's just not making any sense to me. Is there someone that could help
me decipher this spreadsheet so I can make the needed changes? Pretty please?

Thanks,
Kim

Somehow, it's pulling data from the FINAL worksheet, but I don't understand
how it's pointing to a certain cell. I don't understand this part:
"$A5+1,C8" because it doesn't refer to anything that makes sense.

Is there a place that I can send a spreadsheet for assistance? I'm sure
there may be cirical pieces of information that I don't even know to tell
someone about which would assist in solving this for me.

Thanks!

"dlw" wrote:

It looks like it's just checking to see if a cell is empty, and if so it puts
a 0 instead of nothing.

"Kim Nacrelli" wrote:

I have inherited a spreadsheet from a previous worker (who, of course, is no
longer here), and I've spent too many hours trying to figure it out on my
own. I need to make adjustments to the spreadsheet, but don't even know
where to begin because I don't understand the formulas. I'll try to explain
briefly...

There are several worksheets to include some named "FINAL", "DATA" and
"PRINTOUT". Most of the formulas are in the PRINTOUT worksheet. The FINAL
worksheet is simply where data gets dumped from a database (in a particular
order). I just found the DATA worksheet (it was hidden), and it has column
headers without any spaces, and all the other cells in DATA have the
following formula: =TRIM(FINAL!A2)
(replace A2 with whatever the actual cell number is for the entire
worksheet). Also, I noticed that the print area for the DATA worksheet is
huge, but I don't know why...goes down to row 1745 and over to column AX. We
would definitely use the columns with our data, but never down to row 1745.

The PRINTOUT worksheet it where it all happens...I think. There are several
formulas, but they all look very similar. They all return a value from the
FINAL worksheet. Here are some examples of the formulas:
Note - "TITO" refers to a Name of "=DATA!$1:$101"
=IF(INDEX(TITO,$A4+1,C7=0,"",INDEX(TITO,$A4+1,C7)
=IF(INDEX(TITO,$A5+1,C8)=0,"",INDEX(TITO,$A5+1,C8)
=IF(INDEX(TITO,$A14+1,C14=0,"",INDEX(TITO,$A14+1,C 14)

I've been reading about INDEX arrays because I think that's what this is,
but it's just not making any sense to me. Is there someone that could help
me decipher this spreadsheet so I can make the needed changes? Pretty please?

Thanks,
Kim