Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
hi
i have 2 problem. 1) iam using a vlookup formula, but when there is no value in the cell the cell shows the ( 0 for date and jan for month) 0-jan. but i want to be 0 instead of the 0-jan, why its happening, 2) i have a database upto 2000 subscriber paying monthly sub. some customer pays twice in month. i used vlookup formula . it shows only one date , is there possible to show all the date in one cell, so i can know how many times that customer paid the subs in these month. if instead if vlookup i used the sumif formula its add the date and i got the wrong date. so pls help. regards anil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
date() function error | Excel Worksheet Functions | |||
date error | Excel Discussion (Misc queries) | |||
Error in date field | Excel Discussion (Misc queries) | |||
Complile Error with Date | Excel Worksheet Functions | |||
Date Error - HELP! | Excel Discussion (Misc queries) |