Search results

Hello Misra, We got another user case which was not covered earlier. Can you help me with this wherein based on the the first time visit validity period for a user id, can you help in changing all the visits irrespective of the venue code as "Not ok" if this is within the first venue code...

thank you Somendra Misra. Appreciate your help here. the formula worked fine. P.S : apologies for the typo error in the data as well.

Please find attached. the venue and hour logic is also mentioned in the excel.

it will be on daily data only. this will have a max of 30 days data. thanks for the help

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

Thanks Narayan. This is now clear and works fine

Hi Faseeh, Thanks a ton. Appreciate the quick response. Regards

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

the first column should be the city name and from second column onwards, the date should start. Also, I tried entered the formula and I am getting zeros. Can you help me in using this formula as per the sample file attached ?

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