Search results

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

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

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

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

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.

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

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

Folks, Need help. I am trying to mark the duplicate user id who have visited the stall based on the stall size. This needs to be done at user wise. Every venue code has a different duplicate visit validity. E.g if the user visit more than once for Stall number 75 within 24 hours from the...

I am getting configurations results from multiple sites and need to know if all the sites are having same entry. I have attached the sample. Can you check as how this can be achieved with formulas ? the cell content would be either an IP or a domain name...

Folks, I need help in transposing the daily sales data as per the sample Input/ output attached. the data would be appended on a daily basis and I would want the next row to be created, if there is a change in City Name. Can someone help me on this ? Please refer the input sheet for the...