Search results

Hi Shaka, I am not very sure what exactly you are after. According to my guess, you may find the below thread useful for you: http://www.myonlinetraininghub.com/excel-vlookup-multiple-sheets Kaushik

Glad to hear that your problem is solved..

Serene, Can you upload your file (with dummy data) in order to get a speedy solution of your problem? Kaushik

Hi Serene, Try this: =ABS(A1) or =INT(A1)*1 and drag it down to apply to the entire ranges. Where A1 is your data (stored as text). Regards, Kaushik

Hi Shri I was guessing so....thanks for explaining.. You are champ man...I like it very much.. Kaushik

Very elegant... Thanks for sharing this Shri.. Could you please explain this part in words a bit? Kaushik

Hello sasi, I understand that you need to send the report at every 5 days interval (like 5th, 10th, 15th, 20th, 25th, 30th/31st of every month). Is my understanding correct? So code needs to read the date of a month, if it matches our condition it should send the e-mail. We can use...

Hi Vijay , I am not very sure about your entire data set but here is my try: http://speedy.sh/eRRKT/Vijay-test.xlsm In vendor details sheet we have vendor name and code. In search sheet we have vendor name only. According to your problem, we want vendor code to be returned if found in...

danielleeck, Please follow as advised by bobhc. Let us know in case of any issue. Kaushik

danielleeck, Welcome to the forum and we glad to have you here. Suppose your data ranges from A2 to A6. Open CF dialogue box, select "use a formula to determine which cells to format", write the below formula in the box (under "format value where this formula is true")...

jack999, I am sorry but your problem is still not clear to me. It looks like your expected result(43179.125) is 11.11% of Total Value = 388612.13. And you are trying to find out 12.5% Tax Value from the Total Value (388612.13) which is to me nothing but =A2*12.5/100. But this will not give...

@jack999, If it sill doesn't solve your problem then please consider uploading a sample file and give a manual layout of the input and output data of what you are envisioning.. Kaushik

Hi jack999, I am sure I did not get your question properly. You are not trying to calculate =388612.13*12.5/100, I am sure! Could you please tell us what exactly you are after by giving us some more info. Or please wait for someone who would probably understand the problem already Kaushik

@Hui: Your below statement actually answers my question clearly. "The date&time is less than today as that is true even for a Text Comparison". Thank you for your continued help and support. @Narayan: Thank you for your detailed explanation. Regards, Kaushik

Hui, Thank you for your guidance. I noticed that earlier. But I was not able to understand why the code was not working for the first criteria while the same (only difference is the date value in the column is < today) was working for the other criteria (while both the cases the values...

Hi Narayan, It's always been a pleasure for me to have the solution from you. However, may I request you to please explain me the problem involved in the earlier code? Thanks once again for your help. Regards, Kaushik

Hi hoomantt, Copy and paste the below code in "ThisWorkbook" code module(press ALT+F11, double click on "ThisWorkbook",Paste code into the right pane) and save the workbook: Private Sub Workbook_NewSheet(ByVal Sh As Object) With Application .ScreenUpdating = False .DisplayAlerts =...

OOps...I did not see...sorry Chandoo..probably your post comes in when I was working.... Kaushik

Hi prazad82, Try this at C7: =AVERAGEIF($J$5:$J$13,"="&$B7,K$5:K$13) Copy the same down and across. Kaushik

Hi all, I have an annoying problem here. What I am doing here is, based on criteria I am coloring the rows. Criteria1: Fill rows with green if due date = today (Col F contains due date) and status <> pending scoping call (Col G contains project status) Criteria2: Fill rows with...

Hey RK, It's great that you have solved it...and sorry to reply you so late...got stuck in some work. However, here is an another approach without OFFSET function. At D7: =SUMIFS($B$2:$B$100,$A$2:$A$100,">="&$D$4,$A$2:$A$100,"<="&$C$7)/7 Where C7 = today's date D4 = =$C$7-6...

Hi RK, I am not able to download your file from the given link. It's coming as exe file. Can you upload it here? http://www.speedyshare.com/ Kaushik

Hello RK, Your question is not very clear to me. However, I believe you must have the data(previous dates and temperature) stored somewhere in excel. According to my understanding, you want to refer that data and get the average temperature (for the last 7 dates prior today) Could you...

Hi rjwalters, Just curious to know if the above approach helped you by any chance! Kaushik

Hello AJ, I am not able to download your file my friend. It is showing folder is empty. Could you upload it in www.speedyshare.com/ ? It's free and no registration is required. However, below here is my e-mail ID. pharmacyjukaushik[at]yahoo[dot]com Kaushik