Ms-Excel Help

[ALFANI]

Hi..

I'm trying to analyse the web trend report..

 last 1 month data ( http views not sorted)  Downloaded into diff csv files..Is there any way to put all together in order

url day1 day2..

a 10 20 40

b 30 40 60

c 30 50 70 like this kind of report

 

need to prepare a report in excel ...url wise max on which day how many visits ..

 

*<:( some what urgent

[Chitti_Robo_Rebuilt]

ltt

[Journey]

ltt

[micxas]

https://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7

 

this might help you a little..

 

requirement ni batti google chesukunru vellu man, anthe.

[Uchiha]

ltt

[ALFANI]

Thanks all..vlookup ani oka function undi excel lo adi sooper antey super..it resolved my problem..

[compose]

max for a particular URL and the day it happened ki we can do

1. for max : every row lo after the last column create a formula like " =max(B2:J2)" this is with assumption that you have data from column B2 to column J

2. for getting the day : assuming all the days are from B1 to J1 and assuming the max that you created above is in column K in each row we can do put the following formula for every row to show the date when the Max occurred

"=INDEX($B$1:$J$1,MATCH(K2,$B2:$J2,0))"

[compose]

Thanks all..vlookup ani oka function undi excel lo adi sooper antey super..it resolved my problem..

nuvvu ichina format lo vlookup ela work avvutundi cheppu? :)

[micxas]

come pose :)

[ipaddress0]

nuvvu ichina format lo vlookup ela work avvutundi cheppu? :)

(.L@

[ALFANI]

first vlookup vadi anni urls ki day wise vaules techukoni andulo just max of that row antey..