Search results

Maybe your searching the same, pls refer attachment.

Refer attachment maybe your searching the same, I altered some date.

Or else you can use the below formula in Cell F2 =COUNTIFS($B$5:$B$298,"Guest",$A$5:$A$298,">="&"1/1/2021",$A$5:$A$298,"<="&"1/31/2021") in Cell F3 =COUNTIFS($B$5:$B$298,"Guest",$A$5:$A$298,">="&"2/1/2021",$A$5:$A$298,"<="&"2/28/2021")

Is this your searching =COUNTIFS(Sheet1!$B:$B,$A3,Sheet1!$A:$A,">="&"1/1/2021",Sheet1!$A:$A,"<="&"1/31/2021"), refer attached file.

Sorry, I'm not getting, you just copied from my formula, pls check & do the needful.

Hi Team Please find attachment for your reference, in that I need formula 1st 2nd & 3rd Smallest value in range including zero's, I tried by below formula =IFERROR(INDEX($A$2:$J$2,IF(COUNTIFS(A3:J3,0)<=0,0,MATCH(SMALL(A3:J3,1),A3:J3,0))),"") it's working for 1st only, I need 2nd & 3rd Smallest...

Dear Team i have attached a file , where i have given an example of my problem , i want to split a single cell into multiple cells (may be even 10 cells ) based on a criteria example input = 10-5X7X12,12X1X20,6X13X11( in single cell) Output = 10 5 7 12 12 1 20 6 13 11 ( all in different...

Dear All I have a Stock Master file were all the list of stock is there (sold and unsold) . I have sales register where i keep sold files data . every stock has a unique code now i want to see in stock master file what all stock are sold and what all are unsold the results should be...

I created "Slab" Sheet for Data Validation purposes Sheet > PracticeDashboard Cell > K2 find below screen shot & Change date format as I mentioned in attach

Kindly check with Cell K2 Drop down, whether right or wrong, pls revert me.

Hi Rose Torres Exactly what do you want in Dashboard Sheet, please show me some example

Dear Team I already put the formula for Zone/ASM Name & ASM/Officer Name, I need the same formula to Dist cell also in cell C8, Attached file is for your reference. Thanks in Advance Regards Basavaraj K H

is this your searching, pls refer below link http://forum.chandoo.org/threads/required-hirachy-mapping-data-validation-drop-down-depend-cell.24096/#post-145296

Pls refer attachament, if it is match on second condition

FYI... use formula in cell D2 Like below =LOOKUP(C2,G:H,I:I) refer attachament.

Dear Team i got the below mentioned code from Google but from that code i can able remove all special character with full spaces but i don't want to remove single space. kindly modify the below code. Sub test() Application.ScreenUpdating = False Dim rng As Range Dim strg$ i& =...

Hi Say example in cell A1 Type 1 & in cell A2 Type formula like below =A1+1 use the Go to function press F5 or Ctrl G in Reference type A10000 OK or Enter press Ctrl Shift up array & finally press Ctrl D

Dear Team I need Start Time (Cell F3)& End time (cell G3) of TSM Mobile No. as per date wise from "Details" Sheet refer column B C & D respectively. Kindly Refer attached file. Thanks Thanks Basavaraj K H

Hi Chandu, Kindly find the attachment, in that i mentioned the required status in third sheet, in that condition should be come in second page, kindly help me.

Hi Kindly refer below link: http://forum.chandoo.org/threads/required-hirachy-mapping-data-validation-drop-down-depend-cell.24096/#post-145296

For 3rd Question the result what we are getting with pivot table is not satisfactory with the above mentioned formula. Please re check. Expected Output is below, DL01BA8609 UP15AT9491 KA03AA4727 Thanks,

Dear Team Please check the resolution provided for the questions mentioned below with the dump data attached. Help me in case it's incorrect. 1. Which City has the highest bookings on 6th of November? 2. Calculate average value of a booking for each city. 3. Find out the top 3 cars with...

Dear Team This is in regards to sms message to customer mobile numbers in bulk (5000 no.), so I would request to you let us know if we can have the same process & what would be the procedure. Regards Thanks in advance Basavaraj K H

Dear Team Already I have formula in cell BL3 Like below with Array formula (Cntrl + Shift + Enter) {=IFERROR(SUM(IF(G3:BD3>BK3,1,0)),0)} I need same formula in cell BL3 with "Values" column (Yellow Coloured) only (not for Pcs column), using wild cards or ...............,. Kindly refer...

Dear All, I need a help in auto updating the data from the user form(VBA) to Excel sheet. For Example : As soon as i enter the data in the User Form (VBA) and Submit it , then I should have my excel sheet being auto updated. Attached is the User Form(Screenshot) and also the expected form...