Hi Dellosa,
See if the attached file gives you what you need.
Regards - Dave.
Date: Fri, 6 Nov 2009 10:20:53 +0800
Subject: $$Excel-Macros$$ Fwd: FW: lookuphelplease.xls
From: osav...@gmail.com
To: excel-macros@googlegroups.com
Dear Gurus,
Im trying to look up a value from a t
Hi Bonnie,
This is definitely a job for the SUMPRODUCT function, which is a wizz at doing
just what you are asking about.
If you post a sample of your data, there would be many is this group that could
help you with it.
Regards - Dave.
> Date: Thu, 5 Nov 2009 11:36:35 -0800
> Subject: $$Exc
Dear Gurus,
Im trying to look up a value from a table and return a cell reference in a
that worksheet based on the value returned.
quite tricky and i need your help.
I attached a file to explain.
Dellosa
--~--~-~--~~~---~--~~
--
I have acomplex formula I need to plug into an Excel spreadsheet and I
can't figure out how to get the results I need. Can anyone provide me
assistance please?
Here's what I have:
Column D = date of payment
Column E = amount of payment
Column I = category (A, C, F, M, N, D)
Columns J, K, L, M (
http://office.microsoft.com/en-us/excel/HP052091331033.aspx
If this function is not available, and returns the #NAME? error,
install and load the Analysis ToolPak add-in.
John
On Nov 5, 2:32 pm, eric wrote:
> dear ms excel experts:
> my name is eric lin, I had ms excel 2003, but when I open
