What's your criteria for "how many 100 or 150 you can use".
On Fri, May 29, 2015 at 10:04 AM, Rashi Singh
wrote:
> Dear all,
>
>
> Please help in enclosed problem solution. i have tried many and even
> googled, but i am unable to create formula. Have exlplained xl sheet,
> please find.
>
>
> Reg
Dear Vijay,
Where is attached excel file.
On Fri, Jul 19, 2013 at 11:00 AM, vijay yadav
wrote:
> Hi Excel experts,
>
> Please help in above case.
>
> In simple words I need a formula to calculate output considering
> corresponding cell of B column in same row and a cell in A row.
>
> All details
Hi Sajid,
Please find attached solution for your query.
Regards
Chandra Gupta Maurya
On Sat, Jul 13, 2013 at 7:48 PM, Anil Kumar wrote:
> Hi
> pfa
>
> --
> *From:* SAJID MEMON
> *To:* Sundarvelan Natarajan
> *Sent:* Saturday, 13 July 20
<>
Hi Pravin,
It will also help you.
=SUMPRODUCT((C3:C39<>"")/COUNTIF(C3:C39,C3:C39&""))
Regards
On Wed, Sep 5, 2012 at 11:10 AM, Amresh Maurya wrote:
> for unique agency and unique city
>
> use this formula.
> =SUM(IF(FREQUENCY(MATCH(C3:C39,C3:C39,0),MATCH(C3:C39,C3:C39,0))>0,1))
>
> Regards
Dear Kuldeep,
Plz confirm that whether Data in column-A is Date or text. If it's Date
then use bellow mentioned formula to exact 10, and if it's text then you
should first change column A data in text formate to use MID formula to
exact your desired text.
=IF(MONTH(A2)=10,"10","0")
On Sun, Aug 2
Hi Amar,
Plz try this.
=IF(ISERROR(INDEX(august!$C$4:$O$51,MATCH(1,((august!$A$4:$A$51=main!$I7)*(august!$B$4:$B$51=main!$I$3)),0),MATCH(main!J$5,august!$C$3:$O$3,0))),"
",INDEX(august!$C$4:$O$51,MATCH(1,((august!$A$4:$A$51=main!$I7)*(august!$B$4:$B$51=main!$I$3)),0),MATCH(main!J$5,august!$C$3:$O
Hello, Dear
Please check this. Perhaps you need this.
Thanks
Chandra Gupta Maurya
On Mon, Oct 18, 2010 at 7:52 PM, girish kumar
wrote:
> Dear Experts,
>
> need one urgent help from you guys i have attached one file having 2 sheets
> named "system data" & "Ra
Hi Dear
There is problem because cells are in custom format. You should enter this
in general format.
Chandra Gupta Maurya
On Sun, Aug 29, 2010 at 9:51 AM, Ankit Agrawal
wrote:
> Hello Sir,
>
> I need help in separate the num & alpha value in the one cell into another
> t
Please attach the example file
Chandra Gupta Maurya
On Fri, Aug 27, 2010 at 11:21 AM, rajput wrote:
> I have a lot of Data including number & Alphabet , I am confussed
> that duplicate will be entered,,,which command i find duplica
Dear Pankaj
Please select the range where your data is. Then PRESS ALT,H,L,H,D. Now you
can highlight duplicate values any color.
Chandra Gupta Maurya
On Fri, Aug 27, 2010 at 11:04 AM, Pankaj Kumar wrote:
>
> Its cannot help me i provid you an example ; help me to find duplicate
>
You can use conditional formating.
Chandra Gupta Maurya
On Fri, Aug 27, 2010 at 10:42 AM, Pankaj Kumar wrote:
> Hi,
>
> I have a problem i have a lot of data & i wanted to find duplicate record
> is there any fourmula or command in excel.
>
> --
> *Warm Regards
>
Please send the example file.
Thanks
On Mon, Jun 28, 2010 at 10:25 PM, Nadine S wrote:
> I have a cell that I'd like to write a formula that returns all but the
> first 8 characters. The cell's data can be any length. Thanks.
> Nadine
>
> --
>
> ---
Hi
Please find your attached solution.
Thanks
On Tue, May 11, 2010 at 4:04 PM, vinu wrote:
> Hello,
>
> I have a data in two colums like
> A 10
> B 20
> A 30
> C 15
> D 20
> B 25
> A 40
>
> If I use Vlookup will get for lookup up value"A" - it will pick up
> corresponding first occurance only
Hello
Here is your solution.
Chandra Gupta
On Sat, Apr 24, 2010 at 3:03 AM, vinu wrote:
> Hello Frnds,
>
> I have a data like this: columnA -Data & column B- range & column c-
> Data in Range(Need formula for this), Please help me a formula to get
> the ans
Hello dear
Please find the attached solution.
Chandra Gupta Maurya
On Fri, Apr 9, 2010 at 11:41 AM, Anil Saxena wrote:
> Hi Sir,
> plz help me and Show the Formula
>
> --
>
> --
> Some impo
>
> Hi Gaurav,
>
> See this solution, More productive and time saving.
>
> Regards
> Sandeep
>
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceld
Hi Gaurav,
See this solution, More productive and time saving.
Regards
Sandeep
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Joi
Dear
Mike here is your solution.
On Thu, Feb 25, 2010 at 8:23 AM, Mike wrote:
> Hi folks,
> Looking for a function(if it exists) that will grab the first letter
> in a string and put it in another cell. For example:
>
> '12 Roosevelt Ave.'
>
> Some function that will grab the '12' and put it
Dear Ashish perhaps you need this.
Chandra Gupta
On Thu, Nov 12, 2009 at 2:18 PM, ashish koul wrote:
> i want to find the value of adjacent row using vlookup my answer should
> come3 in this case but its not showing that
>
>
> On Thu, Nov 12, 2009 at 12:42 PM, Aindril De
ddins from here.
Chandra Gupta
On Wed, Sep 9, 2009 at 7:04 AM, Subu wrote:
>
> Hi Folks
>
> I have used an add-in on one of my sheets ... and now wish to remove
> that
>
> This is what I have done : Double click the add in sent here, opened
> it on an active work book, sav
Dear Ashish
There will be no problem with this.It will clear all emails.
On Mon, Sep 7, 2009 at 4:20 PM, ashish koul wrote:
> sorry i forget to ask u
>
> this that email can end with.net or .org. or.in etc.
>
> Thanks
>
> ashish
>
>
>
> >
>
--~--~-~--~~~---~--~
22 matches
Mail list logo
