What's your criteria for how many 100 or 150 you can use.
On Fri, May 29, 2015 at 10:04 AM, Rashi Singh rashising...@gmail.com
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
Dear Vijay,
Where is attached excel file.
On Fri, Jul 19, 2013 at 11:00 AM, vijay yadav
vijay.ganesh.ya...@gmail.comwrote:
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
Hi Sajid,
Please find attached solution for your query.
Regards
Chandra Gupta Maurya
On Sat, Jul 13, 2013 at 7:48 PM, Anil Kumar kumarmaury...@yahoo.com wrote:
Hi
pfa
--
*From:* SAJID MEMON sajidwi...@hotmail.com
*To:* Sundarvelan Natarajan excel-macros
attachment: winmail.dat
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 amreshkushw...@gmail.comwrote:
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))
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 26,
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))),
Hello, Dear
Please check this. Perhaps you need this.
Thanks
Chandra Gupta Maurya
On Mon, Oct 18, 2010 at 7:52 PM, girish kumar
girishkumar832...@gmail.comwrote:
Dear Experts,
need one urgent help from you guys i have attached one file having 2 sheets
named system data Raw CDR
i need
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
ankit.agrawal...@gmail.comwrote:
Hello Sir,
I need help in separate the num alpha value in the one cell into another
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 rajputpanka...@gmail.comwrote:
Its cannot help me i provid you an example ; help me to find
Please attach the example file
Chandra Gupta Maurya
On Fri, Aug 27, 2010 at 11:21 AM, rajput rajputpanka...@gmail.com wrote:
I have a lot of Data including number Alphabet , I am confussed
that duplicate will be entered,,,which command i find duplicate records
You can use conditional formating.
Chandra Gupta Maurya
On Fri, Aug 27, 2010 at 10:42 AM, Pankaj Kumar rajputpanka...@gmail.comwrote:
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
Pankaj kumar
Please send the example file.
Thanks
On Mon, Jun 28, 2010 at 10:25 PM, Nadine S n8dine4ma...@yahoo.com 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 vinu1sm...@gmail.com 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 valueA - it will pick up
corresponding first occurance
Hello
Here is your solution.
Chandra Gupta
On Sat, Apr 24, 2010 at 3:03 AM, vinu vinu1sm...@gmail.com 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 answer in column C
Hello dear
Please find the attached solution.
Chandra Gupta Maurya
On Fri, Apr 9, 2010 at 11:41 AM, Anil Saxena anilsaxena170...@gmail.comwrote:
Hi Sir,
plz help me and Show the Formula
--
--
Some important
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.
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
Dear Ashish perhaps you need this.
Chandra Gupta
On Thu, Nov 12, 2009 at 2:18 PM, ashish koul koul.ash...@gmail.com 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
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 koul.ash...@gmail.com wrote:
sorry i forget to ask u
this that email can end with.net or .org. or.in etc.
Thanks
ashish
from here.
Chandra Gupta
On Wed, Sep 9, 2009 at 7:04 AM, Subu mail_to_s...@yahoo.com 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, saved the work book
21 matches
Mail list logo