reciated,
as I use these multi level category axes a lot.
Cheers,
Jay
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free ad
wn to
xls, then open in 2003, it will display the axis correctly on both
charts.
Any ideas as to how to get around this in Excel 2007 would be
appreciated,
as I use these multi level category axes a lot.
B
Hi,
You can use sumproduct formula as below :
=SUMPRODUCT(--(A4:A8>=100),--(A4:A8<=300),(B4:B8))
it's give the same result ...
On Jun 1, 7:52 pm, Dilip Pandey wrote:
> Hi Nidhesh,
>
> Excellent criteria.
> I have attached one file which can be of interest for you.
>
> Note:- If you need some
I have sent your solution on your mail id.
Pls check it.
On May 29, 11:26 am, Prashanth Banneni wrote:
> Hi All,
>
> I have a issue with excel. Hope you can solve it easily :)
>
> I have a list with start date and and end date.
>
> Once i select the start date and end date the range if date
=IF(OR(D5=B5,LEFT(D5,FIND(".",D5)-1)=LEFT(A5,FIND("
",A5)-1)),"Match","Mismatch")
Hi Pooja,
Write this formulas on E5 Cell and dreg it down. it should work.
Great Day..!!!
Ciao..!!
Jai Kishan
On May 26, 11:01 am, Pooja Sharma wrote:
> Hi All,
>
> I need a help, with a condition in wh
Pls use this formulas...
=IF(OR(D5=B5,LEFT(D5,FIND(".",D5)-1)=LEFT(A5,FIND("
",A5)-1)),"Match","Mismatch")
on E5 Cell and Drag it down.
Ciao..!!
Jay
On May 26, 11:01 am, Pooja Sharma wrote:
> Hi All,
>
> I need a help, with a condition i
