i have data date wise. i try to show the value of different date according to their calendar date in one cell. i have attached the document. in once cell i have manually put the value of that date. I want this work from a formula. iN COLOUMN "F" I HAVE filled it manually is there any formula who do this by formula ?
Date wise sum of value
-
-
-
Re: Date wise sum of value
Hello,
Attached is your revised worksheet ...
HTH
-
Re: Date wise sum of value
oh dear i want to product name in F column which i manually written for just example.
i want in column F the product name like see the attached file now. i want a formula who show the product name infront of caledar date like i show in date 11/03/17 see the image[ATTACH=CONFIG]71875[/ATTACH] -
Re: Date wise sum of value
Hello again,
Best solution is to Insert a Pivot Table ...
-
Re: Date wise sum of value
no pivot table its not helping me. my date is not arrange and it can't be arranged. it is only column i have generated a formula but it shows me value dual find the file hope you can correct my formula.
-
Re: Date wise sum of value
Yes, the pivot table can help you ... because it extracts all the data you need for your summary ...
If you consider the pivot table as an intermediate step ...then your summary table can format the information provided by the pivot table ...
Hope this will help
-
Re: Date wise sum of value
i can't entered the pivot table due to my data which is not arrange or have blanks etc there are too much reason due to i am not entering the pivot table.
i have attached my excel sheet please see that. i have generated a formula but it showing result dual i want to see it single product wise.
see that and correct formula . my data is not organized and i can't organized it thats why i am asking for formula !
Regards, -
Re: Date wise sum of value
Extremely difficult to understand what you actually need ...
May be a combination of Index() Match() ... see attached ...
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!