Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel - formula anb VBA
I have a spreadsheet setup thats downloads data from our DB2tables, this
look at the employees and the days off sick. I have been able to get everything to work ok but I'm having trouble with one lot of code and formula. The row that it look at is "K" and this contains either "-" or dates that have been taken as ILL eg.. A .... G H I J K NAME Start Finish Leave Type Hours Med Certificate Joe Smith 01.1.04 05.1.04 ILL 8 - 8 Mrs White 31.12.03 31.12.03 ILL 8 31.12.03-31.12.03 01.1.04 02.1.04 ILL 16 - 03.1.04 03.1.04 ILL 8 03.1.04-03.1.04 OK what I have is =IF(E3=0,"",IF(IF(A30,COUNTA(SelectData(CONCATENA TE("k",TEXT(ROW(A3),"0")))),"")="-"," ",IF(A30,COUNTA(SelectData(CONCATENATE("k",TEXT(R OW(A3),"0")))),""))) Public Function SelectData(StartCell As String) As Range Set SelectData = Range(Range(StartCell), Range(StartCell).End(xlDown)) End Function But this seems to still count the "-" rather than just the dates Waht I need to be able to do is count the number of dates or values in column "K" to the employee but not the "-". eg Joe Smith 0 Mrs White 2 Is this possible --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) |