Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing a Date Function
Ok, I am stuck trying to write a function to do the following, and it would be greatly appreciated if someone could help me. I have two columns, one of data, and another of dates. I need to write a function that filters by dates, and counts the total number of items For Example: My data (column 1) has Members, Non_Members, and Other. My Dates (Column 2) have, well, dates. I have a report sheet that I need to report the numbers. So in the report for each data type (Member, Non_Member, Other) I want to be able to use function (=blah(date I am filtering for less than or equal to)) and have it be able to count Column 1 and put how many returned in column 3 for that date range. Please, this is huge for me and will save days of work. Thanks, Brian -- thebside ------------------------------------------------------------------------ thebside's Profile: http://www.excelforum.com/member.php...o&userid=22736 View this thread: http://www.excelforum.com/showthread...hreadid=387508 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing a Date Function
You have one guess at your post in .misc.
thebside wrote: Ok, I am stuck trying to write a function to do the following, and it would be greatly appreciated if someone could help me. I have two columns, one of data, and another of dates. I need to write a function that filters by dates, and counts the total number of items For Example: My data (column 1) has Members, Non_Members, and Other. My Dates (Column 2) have, well, dates. I have a report sheet that I need to report the numbers. So in the report for each data type (Member, Non_Member, Other) I want to be able to use function (=blah(date I am filtering for less than or equal to)) and have it be able to count Column 1 and put how many returned in column 3 for that date range. Please, this is huge for me and will save days of work. Thanks, Brian -- thebside ------------------------------------------------------------------------ thebside's Profile: http://www.excelforum.com/member.php...o&userid=22736 View this thread: http://www.excelforum.com/showthread...hreadid=387508 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help writing function | Excel Worksheet Functions | |||
Function writing help | Excel Worksheet Functions | |||
WRITING A WHAT IF FUNCTION | Excel Worksheet Functions | |||
Help Writing Function | Excel Worksheet Functions | |||
writing its own function | Excel Programming |