Search results

Dear FondaUK, Why do you want to use countifs? Please make clear. Would you upload a sample file? Regards Muneer

Dear Forum Members, I want to create a lottery engine using RANDBETWEEN. I will click on a command button and get a new lottery number within 1001 to 1500 every time. We will have to consider....... 1. Ticket serial from 1001 to 1500 2. 20 gifts will be given 3. No duplicate lottery number...

Happy Dewali! Regards, Muneer

Mahaveer, Is the attachment is related to your problem? Muneer

Happy to share with you Muneer

Dear Mahaveer, The steps i provided on 08/Nov/2012, it is not possible to solve through macro because you can not use find function in macro. So you can use the latest code. It also works same. Muneer

Dear Mahaveer, You can try the code Range("K1:N100").Select Selection.SpecialCells(xlCellTypeFormulas, 2).Select Selection.ClearContents Range("K1").Select Regards, Muneer

Dear Mahabeer, Select K1:N100 Press Ctrl+F Click on Option>Select Values from Look in Combo>Find All>Press Ctrl+A Close Find and Replace Dialog box Now press Delete key Done! REGARDS, Muneer

Dear Ajinkya, You can try the formula in E2 =IF(COUNTIF(B2,"*"&D2&"*")=1,C2,"Not Found") Regards, Muneer

Dear 5G, Please test the two situations. Situation-1 Think you have 2 excel files in D drive, Book1 and Book2. 1. Open Book1>Go to D3 of Sheet1>Type = (Equal Sign) 2. Open My computer>Book2>Select a cell or 2. Press Ctrl+N for opening a new Excel file>Select a cell...

@KPJ, Please upload your crushed file. It may be helpful for us. Regards, Muneer

@melzjm Please describe clearly your problem. Do you have every separate sheet for separate person? How many sheet do you have? All data in all sheets are same format? Regards, Muneer

Dear Ravindra, You can go to sheet 5 from sheet 27 by using simple hyperlink. Regards, Muneer

thereseexceljakubiak, Would you kindly specify the main problem of your file? Please upload the excel file so that we can see and observe. Muneer

Kaushik, Happy to share with you. Muneer

Dear Ahhhmed, I think you are looking for the cells those are not empty. Without any hesitation you can use COUNTA() formula because it considers numerical,text,non visible things everything. Regards, Muneer

Kaushik, You can try this formula. Type in G2 =INDIRECT(ADDRESS(ROW(A2),COLUMN(A2))) Regards, Muneer

Dear Parikh, Welcome to chandoo's forum. Please state your problem clearly and easily so that other members can understand your problem. You can post a sample file as kaushik quoted. Regards, Muneer

@aparvez007, May be some days ago you posted this problem. Have you seen my response? You can solve this problem by 3-D References in Excel You can get help from the link below...

Ravindra, Happy to help you Regards, Muneer

Dear Ravindra, Type C2=1000 in the sheet 1 Type C2=4000 in the sheet 2 Type C2=7000 in the sheet 3 Type A2=1 in the summery sheet Type the formula =INDIRECT(A2&"!C"&2) in C2 in summery sheet Now you can change the value in A2 (1,2 or 3) and get the magic! Regards, Muneer

@rkspeaks, I tested the formula. It's working. Anyway, you can also find the link below that has been solved by using Pivot Table. https://hotfile.com/dl/176522260/96e4fe2/Indian_Crop_Data.xlsx.html Regards, Muneer

Ravindra Can you use INDIRECT formula? You can get data matching day number and sheet number Regards, Muneer

I am happy to help you

rkspeaks, You can prepare this report by using pivot table. For easily understanding you will have to rearrange the data. Muneer