Search results

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...

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...

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...

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...

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)...

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

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

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 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...

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...

Dear Excel & VBA Experts, I am working on a small project and need to do this routine task of finding if any rooms are booked under the category "T3RRF2" - how do I write the code in VBA for the following (excel file attached - FIND "T3RRF2") 1) Find "T3RRF2" in entire Column D 2) If Column...

Dear All, I would like to ask your help in finding out a formula that would display all rows which fulfill the criteria Example : Cell A1 = 90% and Cell B1 = 96% Given the data in Cell C1 to C300, I would like a formula which will filter and display only the rows which have the numbers...

Hi, I have been able to get the countdown working, just that I have to log off and log in back to see the changes. Does excel have the functionality which displays the countdown as normally (digital) done during any major events. Thanks in advance for your assistance. regards Arjun