Posts by Wafoun

Re: if , any nested formula

Quote from NBVC;688405

Or... =INDEX($A$1:$C$1,SUMPRODUCT(($A$2:$C$20=H4)*(COLUMN($A$2:$C$20))))

Yes, this formula works more than the above one.
Appreciated.

Re: if , any nested formula

may be i didnt know how to express what i want.
attached is a revised excel sheet.
i am unable to use "if" formula to select any item of a list

hi
i have 3 lists, i want them validated but shown in one cell.
col. A have 5 bill types, (Validated "Bill")
col. B have 28 product types, (Validated "product")
col. C have 12 material types, (Valided "Material")

i want in
F2 to select any of the 3 lists.
G2 to recognise them by the validation title.
H2 to categorise them payable or receivables:

attached is the example.
Thank you

Re: counting number of days between anniversary day and payment due date

Appreciate your assistance. i have done my report so quick.
Best wishes and loads of thanks

Re: counting number of days between anniversary day and payment due date

thanks it works with little tweeting... thx again

Re: counting number of days between anniversary day and payment due date

Attached..

hi
i am trying to get the number of days from last time ticket paid till todate, considering the day & month of the hiring date but the year of the last time paid.
say
AAA hired on 15-Nov-2001 receives a ticket every 24 months; received last ticket in Nov 2011.

i want to count
the number of days between 15-Nov 2011 until 31-Jul-2013 (dd & mm are from joining date yyyy from last time paid)
i have a list of 1200 names with different dates of joining and different dates of payments.
thank you

Re: sum if in combination to vlookup

hi
thank you for your help, but i didnt know how to extract the information from the pivot table to the main sheet i work on,
the main sheet is in sheet 1 where i have a main table and need to add the loans outstanding amounts. i rely much on vlookup..
i want
vlookup the client number of sheet 1, in the loan sheet, to extract the loan code 53 outstanding, and in another cell in sheet 1 to extract the loan code 56 and so on..
(pls see attached sheet).
thank you

Re: sum if in combination to vlookup

Thank you,
but this gives the total outstanding amounts for the one client, i want to have the outstanding per loan,
for example client 4810 has two different loans, the said formula totaling up both, how to separate them? and have the answers in to separate cells. one for loan 53 and the other for loan 56.
thx again

I have a table of several columns
Column A client code
Column B outstanding loan amount
column c type of loan numeric code

I have a list of client codes, and want to vlookup the code and sumif the loans referred to that client in a particular loan code.
thank you