Search results

Good Day to all of you I have a file for stock control where i need to see when last time we sell a product. i need a formula in column U which bring the header value in it if that column has got a number value. Column G is Item Ref. Column H is Item Description Column I to T are the columns...

Dear All i have a payment template where i need to instruct my bank to make payment in different currencies and i have to put amount in numbers and words. i want when i put amount in number it convert into text automatically, we are using this formula to convert number into words...

Dear All i have a file where i have 3 databases Actual sales for 2014, 2015 and BU 2016, they are not similar but in all three customer name and brand names are same and based on these two elements of my database i have to make a unique list. i need a formula which can bring customer on a new...

Dear All i have a problem to bring row index number from a different cell by indirect formula in Hlookup. attached is an example of my file... thanks to help me on this... Kind Regards

Good morning all i have to validated data based on Month selected in Column A of a sheet "DATA" in Column B and conditional range is on Sheet List so, if A1 is January B1 should display only dates belongs to January if its March than Dates only for March and so on i did validate this upto July...

Hi I have a file (attached) where i just need those rows which has 2015 in Column 'C' i want to delete everything else... can someone help me to get a macro for this... thanks in advance.

dear all i want to redirect column number in vlookup formula attached is my workring where i need it... thanks for your help.

Good Afternoon to All i have to calculate store earnings based on a % table i want to look up the earning value which fall in between the correct bracket of this table on sheet1. i have attached the file for your reference. hope to get you guys help soon... thanks in advance.

Dear All i am new to charts and need your help to make a chart like i explained in attached file and hope some one can help on this... thanks

Dear All i need to 3 data list and need to validate one of them at a time in A3 based on values in B3. I am attaching a sample file. please guide me how i can do this. thanks for your help. Kind Regards

Dear Ninjas and helping Gurus Good afternoon i need your help to get a formula to display Name of the Brands in column called Display in Sheet Display e.g. columns C, F & I. on sheet Data column A has Warehouse codes and column E has Brands this is coming from system. on sheet Display i have...

Hello all out there, I am in need of your help on covert number in english word, for reference i have attached a file in which i am trying to convert numbers which are in different currencies, into english words... i hope someone from the big gurus will help me out on this. thanks for your...

Hello everyone I am back with another challenge, In attached file I have index and match function which is working fine till the time I need a specific figures to bring in sheet IS-F but now I need to sum all those numbers which are lying under 2010 and 2009 which belongs to criteria F in IS-F...

Hello and a very good morning I recently reinstalled excel on my laptop and since then I have a problem that I can’t work on multiple selected worksheets in a single workbook anymore, when I try to do it excel stop working and a recovery file is start generating. Usually I select all the sheets...

Dear Frnds i need your help to fix my attached file, and i need a macro to delete all the rows based on D column and the criteria will if cell is empty, if it has "Date :" or "Qatar Lu" or "Dimensio" or "--------" or "Period" or "Ledger A". in fact i have a macro for this but it's not working...

hi i have a file where i have 2 sheets, sheet1 is having Data with Name, Nationality, grade achieved etc... on sheet2 have grade achieved i want in A2 cell should have all the names who achieved C1 grade. plz help or let me know if you want me to be for clearer. thanks