Hello Paul,
Thanks its working fine.
I have one more question is there any way we can prevent deleting rows
using VBA.
Regards,
Chandru
On Wed, Jul 25, 2018 at 5:42 PM, Paul Schreiner
wrote:
> You can use:
>
> =IF(AND(COUNTIFS(A:A,A2,B:B,"A")>0,COUNTIFS(A:A,A2,B:B,"B")>
> 0),"Yes","No")
>
You can use:
=IF(AND(COUNTIFS(A:A,A2,B:B,"A")>0,COUNTIFS(A:A,A2,B:B,"B")>0),"Yes","No")
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long
Hello,
Need formula which should check Column A and B For Ex: If CPI have both A &
B then its Yes. IF CPI has only A or B then it should be No.
Regards,
Chandru
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of t
hi Kaushik
use this one
=IF(C3>=VLOOKUP(D3,$F$13:$G$16,2,0),"yes","no")
excel sheet is attached for your reference
*With Regards:*
*CMA** Ankur Pandey*
*B.Com (H), C.M.A *
* Mob: :- +919532513513*
*P* Please don't print this e-mail unless you really need it.
"This e-mail message may
hope this attached fulfill your requirement.
*Regards,*
*For quick responds click here for Message *
On Sun, May 13, 2018 at 6:16 AM, KAUSHIK SAVLA
wrote:
> Hi All,
>
> Attached is the excel file which I am referring for help.
>
> Background: Daily basis there are some transactions getting
Hi All,
Attached is the excel file which I am referring for help.
Background: Daily basis there are some transactions getting created and are
either approved or pending or rejected. For the one's which are pending we
want to build a tracker which once data is dumped it will show whether
follow
I understand that this may not pertain to VBA particularly, but I thought
that I might ask.
I have a spreadsheet that has 4 columns of numbers (simple numbers). A
fifth column has the following equation in it:
=(11.078+1.131*LOG(B2)+0.416*LOG(C2)-0.274*LOG(D2)-0.005*(E2))
I am having issue
Hi guys please help
Regards
Sourav Devrani
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titl
Dear Experts:
Do you know if it is possible to write a formula, then make a checkbox,
whereupon the formula will return different results based on the user's
choice of checking the box or not.
Please see the attached example.
Thank you!!
M.P.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Ex
'=IF(AND(ISERROR(VLOOKUP(A5388,POS!$A$2:$B$97,2,0)),"n/a",VLOOKUP(A5388,POS!$A$2:$B$97,2,0)),IF(ISERROR(VLOOKUP(A5388,POS!$H$5:$I$97,2,0)),"n/a",VLOOKUP(A5388,POS!$H$5:$I$97,2,0)),IF(ISERROR(VLOOKUP(A5388,POS!$O$5:$P$97,2,0)),"n/a",VLOOKUP(A5388,POS!$O$5:$P$97,2,0)),iF(ISERROR(VLOOKUP(A5388,POS!$V$
I would appreciate if someone would look at this formula and tell me what I
am doing incorrectly; I have a large spreadsheet called POS where I have
different variables separated and I am trying to use IF,AND,ISERROR in
nested IF statements and Excel doesn't like what I did. Please see my
form
You can also try this non array formula..
=INDEX(C4:I4,MATCH(TRUE,INDEX((C4:I4<>0),0),0))
Cheers!!
On Fri, Mar 13, 2015 at 8:49 PM, André D'Avila
wrote:
> Thank you very much
>
> André Luiz D´Avila
>
> 2015-03-13 12:13 GMT-03:00 Vaibhav Joshi :
>
> Check formula in col k..
>>
>> Cheers!!
>
Hi André D'Avila,
Please try this formula "=INDEX(C2:I2,MATCH(1,INDEX(ISNUMBER(C2:I2)+0,0),0))"
in cell J2 and also find the attached file.
Regards,
MV
On Fri, Mar 13, 2015 at 8:04 PM, André D'Avila
wrote:
> Dear experts,
>
> I can't figure out how to create a fórmula to this problem.
>
> In t
Thank you very much
André Luiz D´Avila
2015-03-13 12:13 GMT-03:00 Vaibhav Joshi :
> Check formula in col k..
>
> Cheers!!
>
> On Fri, Mar 13, 2015 at 8:04 PM, André D'Avila
> wrote:
>
>> Dear experts,
>>
>> I can't figure out how to create a fórmula to this problem.
>>
>> In the first hand
Check formula in col k..
Cheers!!
On Fri, Mar 13, 2015 at 8:04 PM, André D'Avila
wrote:
> Dear experts,
>
> I can't figure out how to create a fórmula to this problem.
>
> In the first hand seems simples, but i couldn't sove without creating a
> excel macro.
>
> Is it possible to create a fórmu
Dear experts,
I can't figure out how to create a fórmula to this problem.
In the first hand seems simples, but i couldn't sove without creating a
excel macro.
Is it possible to create a fórmula to the challenge bellow?
I attached the file too.
Thx.
André Luiz D´Avila
[image: Imagem inline 1]
ou
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>*From:* Shrinivas Shevde
> *To:* excel-macros@googlegroups.com
> *Sent:* Tuesday, April 29, 2014 6
the people you can,
As long as ever you can.” - John Wesley
-
>
> From: Shrinivas Shevde
>To: excel-macros@googlegroups.com
>Sent: Tuesday, April 29, 2014 6:41 AM
>Subject: $$Excel-Macros$$ Excel formula help
Please find attacehd Sheet
--
Shrini
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, l
Hi Brett,
Instead of studying formula, it will be easy to create alternate formula if
you could provide calculation steps.
Regards,
Swapnil.
On Fri, Jan 31, 2014 at 10:41 PM, Brett Manning wrote:
>
>
> On Friday, January 17, 2014 6:11:10 AM UTC, Rajan_Verma wrote:
>
>> i didnt review the formu
On Friday, January 17, 2014 6:11:10 AM UTC, Rajan_Verma wrote:
>
> i didnt review the formula closely ,but i think you would need some
> mapping kind of sutff to avoid many IF() formulas.
>
>
> On Fri, Dec 27, 2013 at 8:03 AM, Brett Manning
>
> > wrote:
>
>> Hello,
>>
>> As requested, please
i didnt review the formula closely ,but i think you would need some mapping
kind of sutff to avoid many IF() formulas.
On Fri, Dec 27, 2013 at 8:03 AM, Brett Manning wrote:
> Hello,
>
> As requested, please find attached example spreadsheet. The formula's
> concerned are in the metadata worksh
please share the worksheet
On 24 December 2013 15:08, Brett Manning wrote:
> Hello,
>
> I have created a spreadsheet which looks at various different worksheets in
> the same spreadsheet in order to return the data to one central worksheet.
> I have then created a pivot table of this data. My fo
Well, No one will get the result by studying this formula. There will
definitely be number of methods to meet your requirement but for that we
need your master file along with supporting files. Please do share these
with elaborating your requirement.
On Tue, Dec 24, 2013 at 3:38 PM, Brett Manning
Hello,
I have created a spreadsheet which looks at various different worksheets in
the same spreadsheet in order to return the data to one central worksheet.
I have then created a pivot table of this data. My formula below contains
a lot of If's and Index / Match. The formula works but I was
Hi Deepak,
you also try this one
=SUMIF($A$2:$A$9,"Snickers ",B2:B9)+SUMIF($C$2:$C$10,"Potato",D2:D10)
On Wed, Jul 17, 2013 at 7:46 PM, ashish koul wrote:
> =SUMPRODUCT(($A$2:$A$9="Snickers
> ")*($B$2:$B$9)+($C$2:$C$9="Potato")*($D$2:$D$9))
>
> see if it helps
>
>
>
>
> On Wed, Jul 17, 2013
=SUMPRODUCT(($A$2:$A$9="Snickers
")*($B$2:$B$9)+($C$2:$C$9="Potato")*($D$2:$D$9))
see if it helps
On Wed, Jul 17, 2013 at 7:33 PM, Deepak Singh wrote:
>
>
> Hi all,
>
> I want total Calories of Snickers and Potato from below data ..Output is
> 1150, please solve..
>
>
> *ColumnA ColumnB
Hi all,
I want total Calories of Snickers and Potato from below data ..Output is
1150, please solve..
*ColumnA ColumnB Column C Column D*
Candy Calories Fruits & Vegetables Calories Snickers 350 Tomato 10
Twix 370 Potato 40 Skittles 450 Tomato 30 Snickers 35
If you have trouble viewing or submitting this form, you can fill it out
online:
https://docs.google.com/spreadsheet/viewform?fromEmail=true&formkey=dGtJRGJwNkJvdTRQb1JkMUVNOGcwS0E6MQ
Excel formula quiz 1
This quiz is sponsored by discussexcel.com. Ayush Jain Group Manager
Your name *
E
try this UDF. Check the attachment.
Function con_2(irng As Range)
Dim sirng, i As Long, out2 As String
sirng = Split(irng, " ")
For i = LBound(sirng) To UBound(sirng)
out2 = out2 & Left(sirng(i), 2) & " "
Next
con_2 = out2
End Function
On Sun, Nov 4, 2012 at 12:40
Hi,
What if A1 hold more than 3 values?
example: "Bill William Gate Junior"
I would like the formula to take in consideration any number of values
example: "Name1 Name2 Name3 Name4 Name(n)"
Thanks
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM
Hi,
please find attachment.
*Best Regards,*
*Ms Excel User*
On Sat, Nov 3, 2012 at 11:43 PM, cyberuser wrote:
> Hi,
>
> The text is located in a single cell and it can be of variable words...
>
> example:
>
> Cells A1: "John Doe Junior"
> Cell B1 should return "jodoju"
>
> or
>
> Cell
ok then use LEFT($B$12,2)&LEFT($C$12,2)&LEFT($D1$2,2)
On Sat, Nov 3, 2012 at 11:43 PM, cyberuser wrote:
> Hi,
>
> The text is located in a single cell and it can be of variable words...
>
> example:
>
> Cells A1: "John Doe Junior"
> Cell B1 should return "jodoju"
>
> or
>
> Cell A1: "John Doe"
Hi,
The text is located in a single cell and it can be of variable words...
example:
Cells A1: "John Doe Junior"
Cell B1 should return "jodoju"
or
Cell A1: "John Doe"
Cell B1 returns "jodo"
Thanks
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORU
plz put range as per ur requirement
On Sat, Nov 3, 2012 at 11:24 PM, Rohan Young wrote:
> HI,
>
> TRY DIS =LEFT(B12,2)&LEFT(C12,2)&LEFT(D12,2)
>
> REGDS
>
>
> On Sat, Nov 3, 2012 at 11:14 PM, cyberuser wrote:
>
>> Hi,
>>
>> Is there a formula that would the 2 first characters from a name, eg
HI,
TRY DIS =LEFT(B12,2)&LEFT(C12,2)&LEFT(D12,2)
REGDS
On Sat, Nov 3, 2012 at 11:14 PM, cyberuser wrote:
> Hi,
>
> Is there a formula that would the 2 first characters from a name, eg.
> first, and/or second, and last name?
>
> example:
> in cell A1:
> "John Doe Junior"
> in cell B1 the formu
Hi,
Is there a formula that would the 2 first characters from a name, eg.
first, and/or second, and last name?
example:
in cell A1:
"John Doe Junior"
in cell B1 the formula would render:
jodoju
or if "John Doe"
jodo
Thanks
--
Join official facebook page of this forum @
https://www.facebook
Hi group,
Hope you will post an excellent solution here :
Let suppose you have a string like below :
A|A|A|B|B|C|A|B|C|D
As you can see the characters are being repeat in this string
output should be : A|B|C|D
I don't think helper column is required J
You can comment here also
htt
Dear Friends,
Does any one have training material in ppt form for all excel formulas (basic &
Advanced)? If you please forward, this will help us to train others in the
organization.
Best Regards,
Amit
Disclaimer: This message and its attachments contain confi
OK
Replace the B3 formula on sheet1 with
=IF('P&L (2)'!$H$4="ALL Year",2,MATCH('P&L
(2)'!$H$4,INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A4:i4"),0))
and in b12 and copy down & across
=IF(ISNUMBER(MatchCol),IF(COLUMNS($A12:B12)<=$H$6+1,INDEX(INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A5:i120"),
Mar 2012 00:56:33
To:
Cc: Kris;
Subject: Re: $$Excel-Macros$$ Excel formula help needed
PFA
Kris
On Saturday, 24 March 2012 12:51:10 UTC+5:30, Kris wrote:
>
> It does. Set your calculation to automatic.
>
> Kris
>
> On Saturday, 24 March 2012 12:43:42 UTC+5:30, hi
n you select another year.
> Sent from my BlackBerry® smartphone from Airtel Ghana
> --
> *From: * Kris
> *Date: *Fri, 23 Mar 2012 21:50:49 -0700 (PDT)
> *To: *
> *Cc: *
> *Subject: *Re: $$Excel-Macros$$ Excel formula help needed
>
> Hi
>
>
21:50:49
To:
Cc:
Subject: Re: $$Excel-Macros$$ Excel formula help needed
Hi
In B3 on Sheet1
=IFERROR(MATCH('P&L
(2)'!$H$4,INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A4:i4"),0),2)
Define B3 '*MatchCol'*
*
*
Now in B12 and copy dow
Hi
In B3 on Sheet1
=IFERROR(MATCH('P&L
(2)'!$H$4,INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A4:i4"),0),2)
Define B3 '*MatchCol'*
*
*
Now in B12 and copy down & across,
=IF(COLUMNS($A12:B12)<=$H$6+1,INDEX(INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A5:i120"),ROWS(B$12:B12),MatchCol+COLUMNS($B12:
@googlegroups.com
Subject: Re: $$Excel-Macros$$ Excel formula help needed
OK. In B12 and copied down & across,
=IF(COLUMNS($A12:B12)<=$H$6+1,INDEX(INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A5:i120"),ROWS(B$12:B12),MATCH($H$4,INDIRECT("'"&INDEX(S
Thanks Kris its working great. 100% THIS time around
Maries thanks a zillion too your formula is also working 100%
i just realised that you made cell B11 an absolute reference, i just
changed it to B$11 and its now working 100%.
thanks both for you assistance
=IFERROR(CHOOSE(index,INDIRECT("AL
OK. In B12 and copied down & across,
=IF(COLUMNS($A12:B12)<=$H$6+1,INDEX(INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A5:i120"),ROWS(B$12:B12),MATCH($H$4,INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A4:i4"),0)+COLUMNS($B12:B12)-1),"")
Kris
>
--
FORUM RULES (986+ members already BANNED for violati
i think i get excited over the first few trials but i just realised a few
bug .the figures doesnt match the years when you for instance select a
year to view
On Fri, Mar 23, 2012 at 3:41 PM, hilary lomotey wrote:
> Kris, this solution is spot on. thanks working to perfection
>
>
> On Fri, Mar
Kris, this solution is spot on. thanks working to perfection
On Fri, Mar 23, 2012 at 3:33 PM, Kris wrote:
> Hi
>
> on Sheet1
>
> In D2:D5
>
> FML SIC GCB GGBL
> and define the range *'ShtName*'
>
> Define B2 '*SheetSelected*'
>
> In A12 and copied down & across on P&L(2)
>
>
> =IF(COLUMNS($
Hi
on Sheet1
In D2:D5
FML SIC GCB GGBL
and define the range *'ShtName*'
Define B2 '*SheetSelected*'
In A12 and copied down & across on P&L(2)
=IF(COLUMNS($A12:A12)<=$H$6+1,INDEX(INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A5:i120"),ROWS(A$12:A12),COLUMNS($A12:A12)),"")
Kris
>
>
--
FO
Hi Maries
The formula works perfectly for SIC, however for GCB and GGBL, it seems to
pick the same figures for all the years. with FML , its picking the an
incorrect figures.
kindly verify for me. thanks
On Thu, Mar 22, 2012 at 8:30 PM, Maries wrote:
> GCB & GGBL Error Rectified. PFA latest.
>
genius Maries
Great solution. works to perfection. thanks boss
On Thu, Mar 22, 2012 at 3:56 PM, Maries wrote:
> HI,
>
> Please find the attached file of Revised one. Ignore Previous one.
>
> Regards,
>
> MARIES.
>
>
> On Thu, Mar 22, 2012 at 7:07 PM, Maries wrote:
>
>> Hi,
>>
>> PFA.
>>
>> =I
HI,
PFA.
Regards,
MARIES.
On Thu, Mar 22, 2012 at 4:40 PM, hilary lomotey wrote:
> Hi Oxford Excel Gurus
>
> In the fill attached sheet "P&L" i have been able to write a formula that
> can show how many number of years i want to view the report ie if i want to
> see 5 years report i will sele
Hi Oxford Excel Gurus
In the fill attached sheet "P&L" i have been able to write a formula that
can show how many number of years i want to view the report ie if i want to
see 5 years report i will select from the drop down, and so forth. and the
number o years specified will show
In the 2nd shee
=Text(YourDate,"mmm-yy")
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Imran khan
Sent: Jan/Tue/2012 12:25
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel formula for Dates
I have date 17-Jan-12. I want formula to ge
Dear Imran,
Please try
=text(17-Jan-12,"mmm-yy")
On Tue, Jan 17, 2012 at 12:25 PM, Imran khan wrote:
> I have date 17-Jan-12. I want formula to get only Jan-12. Please help me.
>
> Regards,
> Imran
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thr
*=TEXT(A1,"MMM-YY")
*
On Tue, Jan 17, 2012 at 10:55 AM, Imran khan wrote:
> I have date 17-Jan-12. I want formula to get only Jan-12. Please help me.
>
> Regards,
> Imran
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread title
I have date 17-Jan-12. I want formula to get only Jan-12. Please help me.
Regards,
Imran
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice wi
Thanks All.
It works excellent.
Regards,
Kaushik
On Wed, Jul 27, 2011 at 1:18 PM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:
> If you need a formula use SUMPRODUCT or SUMIF
>
> See the attached.
>
>
> HTH
> Haseeb
>
> For Tips visit;
> http://www.excelfox.com/forum/forum.php
>
> --
>
See the attached File,
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabhu
Sent: Thursday, July 21, 2011 10:54 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel formula help
Hi Friends,
In the attached sheet wherever we
try the attached file
On Fri, Jul 22, 2011 at 2:33 AM, Vikas Chouhan wrote:
> try this
>
>
>
> =IF(ISERROR(REPLACE(A2,FIND("Opt.",A2),3,"#")),A2,(REPLACE(A2,FIND("Opt.",A2),3,"#")))
>
>
> On Thu, Jul 21, 2011 at 10:54 PM, Prabhu wrote:
>
>> Hi Friends,
>>
>> In the attached sheet wherever we
try this
=IF(ISERROR(REPLACE(A2,FIND("Opt.",A2),3,"#")),A2,(REPLACE(A2,FIND("Opt.",A2),3,"#")))
On Thu, Jul 21, 2011 at 10:54 PM, Prabhu wrote:
> Hi Friends,
>
> In the attached sheet wherever we find *"Opt. "*(Opt dart and a space) is
> replace with # and add with the previous cell which doe
Hello Prabhu,
Use this in B2 & copy down.
=IF(ISNUMBER(SEARCH("Opt. ",A2)),LOOKUP(2,1/ISERROR(SEARCH("Opt.
",A$2:A2)),A$2:A2)&SUBSTITUTE(A2,"Opt. ","#"),A2)
Then copy Col_B *Paste Values *in Col_A. Then after delete Col_B.
HTH
Haseeb
--
--
: jeudi 21 juillet 2011 19:24
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Excel formula help
Hi Friends,
In the attached sheet wherever we find "Opt. "(Opt dart and a space) is
replace with # and add with the previous cell which does not contain
"Opt."or
Hi Friends,
In the attached sheet wherever we find *"Opt. "*(Opt dart and a space) is
replace with # and add with the previous cell which does not contain
"Opt."originally.
As per the attached sheet A9,10,11,12 we have to remove "Opt. " and add #
with A8 as prefix.
Similarly in A3 "Opt. 0D1"
Have a look at the attached workbook.
Daniel
- Mail Original -
De: "RockyFontane"
À: "MS EXCEL AND VBA MACROS"
Envoyé: Samedi 16 Juillet 2011 18h06:05 GMT +01:00 Amsterdam / Berlin / Berne /
Rome / Stockholm / Vienne
Objet: $$Excel-Macros$$ Excel formula for C
I have a table where I maintain a log of every contact event I make
with my customers. In a Pivot table, I'm trying to return and
calculate the first contact event made by unique ID. When I pivot by
ID and dump in "Log Contact", it sums up all the contacts. If I use
the Max function, then it doe
Hi Vinod,
Please share the test file.
Regards,
DILIPandey
On 7/8/11, vinod rao wrote:
> Hi,
> I have put a pivot table and i need to get Gross% starting from 0% and above
> data listed in pivot. Can i know how to get in pivot by by adding formula?
> My data has both -ve and +v % but what i need
Hi,
I have put a pivot table and i need to get Gross% starting from 0% and above
data listed in pivot. Can i know how to get in pivot by by adding formula?
My data has both -ve and +v % but what i need is any % with greater than 0%
Regards,
Vin
--
-
Hi,
In L8 :
=SUM(OFFSET($D8MONTH(TODAY(
If you are to use todays month.
Cheers.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de vinod rao
Envoyé : mardi 12 avril 2011 19:24
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros
Thank you for your solution.
On Wed, Apr 13, 2011 at 10:19 AM, STDEV(i) wrote:
> try this formula and see if it helps
>
> =SUM(OFFSET($D8:$I8,0,0,1,MONTH(TODAY(
>
>
>
> On Wed, Apr 13, 2011 at 12:23 AM, vinod rao wrote:
>
>> Hi,
>> I need a formula adding each month one column.
>> Attached f
try this formula and see if it helps
=SUM(OFFSET($D8:$I8,0,0,1,MONTH(TODAY(
On Wed, Apr 13, 2011 at 12:23 AM, vinod rao wrote:
> Hi,
> I need a formula adding each month one column.
> Attached file has a details.
>
> Regards,
> Vin
>
--
--
Hi,
I need a formula adding each month one column.
Attached file has a details.
Regards,
Vin
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/excelda
Look at the attached file and run the macro « Test »
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Dilan De Silva
Envoyé : mercredi 23 mars 2011 13:28
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ Excel formula for a
>
> Regards.
>
>
>
> Daniel
>
>
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Dilan De Silva
> *Envoyé :* dimanche 20 mars 2011 08:41
> *À :* excel-macros@googlegroups.com
> *Objet :* $$Excel-Macros$$ Ex
excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Excel formula for a BOQ
Dear friends,
Please refer the attached excel sheet.
I want to get the Item nr and relavent percentage in to a one row for each
item.
For example,
Item A and relavent percentage (105%) is in one row, but I
Dear friends,
Please refer the attached excel sheet.
I want to get the Item nr and relavent percentage in to a one row for each
item.
For example,
Item A and relavent percentage (105%) is in one row, but Item B and
percentage(150%) not in a on row. Then, I want to get the 150% to above row.
Ho
As Your formula is circular , it will cause error
Go to Excel Options>Formula>Iterations>Check the box on
restart excel
Error will not get there
On Fri, Feb 18, 2011 at 8:33 PM, vitorjose wrote:
> I prepare construction estimates and am required in some cases to add
> costs for providing a pe
I prepare construction estimates and am required in some cases to add
costs for providing a performance bond. I arrive at a total price
lets say $1,000,000 then add in bond cost at $10 per thousand
(10,000). If am successful i receive a contract for 1,010,000 from my
customer. When i go to my bo
Hi,
The attachment is the solution of your Problem.
What i have sent you it's just a way to gather information and
location of integer value in cell.
And one more thing to Chandra don't mag,up excel formula,Understand them.
After it work Once you understand the formula and how to use it.
Regar
Hi,
Nice formula but its not working with this data a 958 b 951 will return same
value is there any way to do this.
Thanks
Chandra Shekar
On Wed, Nov 3, 2010 at 7:48 PM, Vishal Parihar wrote:
> Hi All,
>
> Today i am going to show that how we can separation of integer
> in single cell by
Hi All,
Today i am going to show that how we can separation of integer
in single cell by using excel
function.
if data in cell like |vishal parihar 9910415530| or |vishal parihar
9910415530 vishal parihar|
by using below function one, Output like this |9910415530|.
Function One :
=MID(A1,
Hi,
Can u explain me what is ur query
i did some this pls have a look
On Thu, Mar 18, 2010 at 2:31 PM, Venkatesan c wrote:
> Dear All,
>
> Any one can Assist me attached file query It's something like reverse Lookup
>
> --
>
Simplest possible. But needed unique list (no duplication).
Regards
Sandeep
On Thu, Mar 18, 2010 at 8:37 PM, Dilip Pandey wrote:
> Dear Venkatesan,
>
> Attached file has two solutions for your query.
> Let me know in case of any challenge(s).
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY
Dear Venkatesan,
Attached file has two solutions for your query.
Let me know in case of any challenge(s).
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Thu, Mar 18, 2010 at 2:31 PM, Ve
just applt vlook and get the data
On 3/18/10, Venkatesan c wrote:
>
> Dear All,
>
> Any one can Assist me attached file query It's something like reverse
> Lookup
>
> --
>
> --
> Some important links for excel users:
Try the following attached file
This is a left lookup
On Thu, Mar 18, 2010 at 5:01 AM, Venkatesan c wrote:
> Dear All,
>
> Any one can Assist me attached file query It's something like reverse
> Lookup
>
> --
>
> --
Dear All,
Any one can Assist me attached file query It's something like reverse Lookup
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
Hi there,
I was wondering if there is any body who could help me with a formula
that i am having great difficulty with.
Platform:
I have one spreadsheet open with three worksheets that are used.
1= phead - Contains Purchase order numbers and dates of the order but
no information what was ordered.
Hello All!
How are you? I hope fine!
I need your help, please. I'm writing a formula into a cell by a VBA
Code:
ActiveCell.Value = " = COUNTBLANK(" & CStr(RefEdit1.Value) & ")"
So, when I run this code, that cell returns "#NAME".
I just open the cell value to edit (but I edit anything) and say
90 matches
Mail list logo
