Search results

thanks, again. I will give it a try. Appreciate the quick help

thank you very much. As i said, its the sample. I have 6000 such location codes or Data Input as per the code. Do i need to pass only in the query all 6000 or can this managed by refering the values in another array and then do the count with the actual data ? Appreciate the help here.

Folks, I have attached the sample file where in the location code and the products under the location is mentioned one below the other. Location code sample : 203010 I would need the count of products at location code as per the output required format mentioned in the same file. the location...

thank you very much. Appreciate the quick support.

Thanks Bosco and Chihiro. For some reason, this is expecting all cells to be blank after 100.5 as a last value. If I enter a cell with some value, then the count is not same.

Hello team, can you please help to count the blank cells after 100.5 in a row ? i have attached the sample excel file and the expected result in result column. Please help Regards, Murari Rajagopalan

Many thanks Narayan. this works.. thanks again for the help. Much appreciated !:awesome:

thank you very much. can i use an arrary in column B instead of one specific value ? I did tried with the formula as attached and this seems to be not working.. In the sense, every column in cell A, will be checked with all values in Cell B rather than a specific value

Hello Narayan, I just tried by changing the value and this is not working. can you please help to check once ?

Hello there, I am trying to match a specific cell value in column B with the data in Column A and expecting the result in Column C as Yes or No.. In the sense, Column A data should be checked with all values in Column B and if there is a find, it should print as Yes. There will be only one...

thanks to everyone ! Appreciate the support !

Hello There, Need help. I have data in excel wherein the Empid is repeated multiple times in rows and need to output @ employee level as per Sheet 2. I can create the column header manually based on the maximum value found as well. Please help Regards Murari R

Thank you very much.

Can you please help with the change wherein the macro will overwrite the same sheet for every 5 minutes refresh with the data ? Right now, its creating new sheet and importing the data.

I have uploaded a sample CSV file. If you click Refresh, this would pop up the Open File window. Need help in suppressing this one

Folks, I am trying to import a text file which gets updated every hour in excel using Data>From Text and mentioning the URL in the File name path. it works fine and data is getting loaded in excel. When I set automatic refresh for every 60 minutes and during refresh, "Open" file window keeps...

thank you very much. that was very quick. Appreciate your support

Please find attached the excel file which has the tickets closure time. Based on the closure time and priority, the performance rating should be captured based on the performance rating calculation as outlined in Colum J, K, L. Can you please help me with a formula where in the perfornance...

thank you Misra for the help. Much appreciated !

yeah, thats correct. apologies for the error!

thank you very much Misra. Only small change. the excel is correct and red color highlighted one is for user id 1084. Also, as confirmed to you, please consider the first time visit for each user id and then take the venue code and then derive ok and not ok based on validity. so for 1084, the...

yes, thats correct. we need to take the first time visit for the calculation. Infact, I have uploaded the revised one sometime today. I have also uploaded with this response as well

yes, thats correct. the logic is based on the first visit venue code and then decide ok and not ok based on the validity time of the venue code. thanks

Sure Misra. User 1083 came to the exhibition and visited stall 75 on 3/14/2014 10:30:32 AM. Stall 75 has a validity period of 24 hours. User 1083 then visited stall 20, 2 times and Stall 30, 1 time. All these visits are now happened in 24 hours validity window for the first time visit of the...

Can someone help me with the query as stated above please ? thank you