Dear All
In attach sheet i am getting error in hlookup if i use if condition, please
assist.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Vi
Hi Subu
find the attach file which produce the result of VOOKUPIF ( ) function. Be
careful about the conditions for the formula if you want correct result.
Sandeep
- Original Message -
From: Subu S
To: excel-macros@googlegroups.com
Sent: Saturday, August 22, 2009 6:56 PM
Sub
Dear,
What formula do you use for adding values please reply
From: excel-macros@googlegroups.com
[mailto:excel-mac...@googlegroups.com] On Behalf Of JAYAVELU SUN
Sent: Saturday, August 22, 2009 5:21 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Imp - A
On Sat, Aug 22, 2009 at 6:22 PM, mahesh parab wrote:
> Dear All
>
> In attach sheet i want to protect particular cells of sheet, from protect
> sheet option i can
> protect whole sheet but i want to keep yellow colour cells in attach sheet
> editable & green colour whole sheet protected.
> for bo
Great Solution Mr. *Aindril De.*
*That's what I am serching for.*
Please can you tell me in detailed (or send a link) about "Custom
Formatting" which is a very powerfull in Excell.
Thanks in advance.
Regards,
Dhananjay
On 8/16/09, Aindril De wrote:
>
> Dear Dhananjay,
>
> YOu can do a simple
Hi Dave,
Thank you for this great information. These kind of things are not available in
many books. Thanks again for this.
Thanks & Regards
Sandeep
- Original Message -
From: Dave Bonallack
To: excel-macros@googlegroups.com
Sent: Saturday, August 22, 2009 7:42 PM
Subject: $
Hi Anil + jonell,
Thanks for considering my problem.
Yes the Total is also based on the grace marks.
Thanks & Regards
Sandeep
- Original Message -
From: jonell
To: excel-macros@googlegroups.com
Sent: Thursday, August 13, 2009 12:39 PM
Subject: $$Excel-Macros$$ Please Help M
Hi
vinod
Use rank formula
e.g
=rank()
On Fri, Aug 21, 2009 at 2:16 PM, vinod rao wrote:
> Hi Team,
>
> Not in this way. :(
>
> First i do not want to sort.
> Second the ranking should be based on Glass and should not consider the
> city or district.
>
> Example
> Glass- Based on bigest value it
Hi Sandeep,
The -- works on logical values, changing them from True to 1, or from False to 0
Try putting 5 into Cell A1
Then put =(A1=5) into Cell A2
When you hit Enter, Cell A2 will read TRUE
If you change A1 to something else, Cell A2 will read FALSE
Now change Cell A2 to =--(A1=5)
When you hit
HI TAlgo
FIND THE ATTACH WHAT YOU WANT
I HOPE THIS IS HELP
JAYAVELU
On Fri, Aug 21, 2009 at 8:57 PM, TAlgo wrote:
>
> I have a cell A1 in which I enter a number value everyday. I was
> hoping some type of function or form in differet cell B1 so each time
> A1 is updated it add up previous A
Hi Prasad,
Please find the attached excel. I just tried ,don't know whether its correct
or not Please have a look.
Regards,
Sreevijay
2009/8/18 Prasad Gadgil
>
> *Dear All,
>
> **Case: *There are four different rate cards (A,B,C,D) & now i have to
> calculate the brokerage depending upon rat
YOu can try the following if it is not protected:
Under Tools | Options | View Tab
Check the radio button selection for Objects. Change from "Hide All" to
"Show All"
Please let me know if this helps.
Regards,
Andy
On Sat, Aug 22, 2009 at 2:06 PM, Aindril De wrote:
> Is your worksheet protected
On Fri, Aug 21, 2009 at 1:09 PM, vinod rao wrote:
> Hello Team,
>
> I have attached file in which i need a formula in the column E, instead of
> the manual ranking in need a formula based on the item mentioned in the
> column C.
>
> Please make a note, ranking is based on the largest value to the
Is your worksheet protected???
Regards,
Andy
On Fri, Aug 21, 2009 at 10:58 PM, Tommy wrote:
>
> When I bring up the Forms toolbar there are some controls that are
> grayed out, specifically the Dropdown List and some others. Can anyone
> shed any light on this. I am trying to construct a form a
14 matches
Mail list logo
