I need day in another row beside to date row
Suppose like a1=date b1 should get day and for this any formula can be applied.Please mention anybody.
For example
A1 B1
6/9/2012 THURSDAY How to get through formula
Hai,
I needed total sum of number of pages corresponding to date-wise.
DATE ARTICLES NO. PAGES TOTAL
4-Sep-12 PJ2012143 20
NC201253 30
SC201298 32
5-Sep-12 PJ2012143 18
NC201253 32
SC201298 18
for example: In 4Sep, no of pages=82, so i need this to be done by applying...
I am not able to understand Mr.Narayan what you have posted the answer for my question on taking filter on a row. So, anybody explain me properly on Narayan has posted.
Thank you, for your reply but i require is
A1 contains "JAGANNATH" and B1 contains "JAGANATH"
My question is when comparing A1 and B1, letter 'N' is missing. So missing letter should be highlighted but not entire cell.