Search results

@Luke M Thank you, works perfectly.

Dear Xcel Guru' Need your assistance, I have the attached sheet wherein I want to put the formula in Cell G1 - This is based on Value in Cell F1 - Look up Col C and when the exact match is found - display the corresponding cell value from Col A (date). In the sheet the Cell F1 = 126,879 so the...

Awesome!! Thank you @pecoflyer

Dear Gurus, I am looking for a formula that can look for the last entry in a range of cells. Eg: Attached sheet - last entry in Column B (range B2:B32) is 1,596,088 - similarly other columns. I want to know if there is a formula that can be inserted in Cell B33 which will always look up the...

Thank you @Peter Bartholomew for the new formula, as I am using Office 2013 version currently... will keep the formula on file for future reference.

Thank you @AlanSidman, this works perfectly.

Dear Gurus, I am looking for a formula (E2) which can count the number of cells which has a ">=D2" from the range $B$2:$B$273, the same formula then continues into cell E3,E4,E5.... while criteria will be cells D3, D4,D5... As the list is updated often and then a graph is related to it, I...

Thank you @deciog and @p45cal both options work good. I want to go a bit further, if the data range changes as attached wherein the reference cells are B5:G14 - what would be the formula' then. Thanks once again in advance

Dear Excel Gurus, Need your help, I would like to know how many entries in column L have a values as listed in Cells B1, C1,D1,E1.... (these are set as text, would actually want it also as numbers). I have done a simple countif in column P but really looking for the table format A1:I2 Highly...

Thanks Peter, this works great.

Dear Excel Gurus, In the attached document I have entered Date in cell A1, formula added in cell B1: AE1. Based on values in cell A1:AE1 cells A2:AE2 values display "ddd" format. Conditional formatting has been done in cell A2:AE2 to change color based on Weekday and Weekend. (Fr & Sat)...

Thank you very much, works perfectly.

Dear Gurus, Looking to use CONCAT however the result in cell B8 does not give the currency sign of cell B4, further it is more than 2 decimal values. Want the final value to display as cell B10. Attached is the sample file created to explain the same. Thanks in advance. Kind regards

Awesome, Thank you @Excel Wizard. The formula does exactly what I was looking for.

Dear Excel Gurus, From the attached sheet, I want to set a formula where in lookup for date range between Cell A2:B2 in G1:UE1, then go to G2:UE2 and make cell values = 1. Appreciate your guidance Kind regards Arjun

Thanks a lot Naresh, works perfectly as I was looking for.

Apologies for not being clear in my expectations, in the attached sheet I have added more data - hope I can explain better this time). Col A has the Full Price Amount, Col B is the Discounted Price (19% has been done manually), Col C is the Discount Amount - If I change the Discount % Cell C1...

Dear All, I would like to automate the process, wherein anytime a Discount Percentage is entered in Cell E2, the Discounted Price Cell B4 and Discount Amount Cell B5 must change. Attached is the sheet I have manually put the formula in cell B4 - want this to update auto. Thanking in...

Hi Marc, Thanks once again for your reply, however I am getting an error as follows Compile error: Invalid use of Me keyword. Could you please share how I can resolve this. Looking forward.. Kind regards Arjun

Hi Team, I am looking for vba code to complete the following task (data sample attached) Sheet1 - Data File - is my Daily Extract File. Sheet2 - Task 1: Column A has values while there are blank rows in between, I want to know a vba code which can copy the values in Col A and paste in the...

Thank you Marc, got it! Task completed.

Dear Marc, Apologies, I do not understand. Can you assist in solving the issue.

I have tried recording macros doing the Control+Find / Replace option but land-up with incorrect output. Normally end up removing the '0' from 10,20 and 30 not what I want... Code needed to do the following: 1) Cell B4:O8 - Look for '0' (Zero) - not the 10,20,30.... (basically anything less...

@Fluff13 - The code is amazing, took the details and pasted on a similar challenge I have been facing. Works perfectly!! Thank you once again for sharing..

Sorry, I question - does the MsgBox background color have to be the Standard Grey or can that be changed also - may be to color BLUE Thanks once again.