THANKS A LOT
On Mon, Dec 10, 2012 at 11:59 AM, David Grugeon wrote:
> IF(A2,A2,B2)
>
> Regards
> David Grugeon
>
>
>
> On 10 December 2012 15:20, The Viper wrote:
>
>> other ways for shortening the formula
>> =IF(A2=FALSE,B2,A2)
>> or
>> =SUBSTITUTE(A2&B2,"FALSE","")
>>
>>
>> On Mon, Dec 10, 201
Insufficient information provided.
You have posted 4 apparently identical workbooks although Report1.xls is
slightly larger than the others so there must be some difference. What is
it?
Could you provide a workbook called, say, Result.xls with at least 2 or the
source reports included. This wil
any help
Moderator could you please help on this
On Mon, Dec 10, 2012 at 11:24 AM, Puttu * wrote:
> can any one please...
>
> Need a macro to 5 workbook data to paste in single workbook, on one by one
> in the same sheet
>
>
> On Mon, Dec 10, 2012 at 12:05 AM, Puttu * wrote:
>
Dear excellerner,
Use $ sign to make constant row or column .
for eg
if u select A1 A10 then write $A$1 $A$10.
first $ is for column and second $ is for row.
you can use only one $ for only one column like $A1 or you can use only one
row like a$1 .
Regards,
Gawli
On Mon, Dec 10, 2012 at 12:31 PM,
Sir
Please see the sample and help me.In this file Row C4 to AD 4 has
amount to be paid for each unit.If emp-1 done 2 units in c5 then
c5*c4 , emp-2 done 3 units in c6 then c6*c4. as same up to AD to all
employes. I already set formula in AE for all employes.Please verify
and suggest me for simp
IF(A2,A2,B2)
Regards
David Grugeon
On 10 December 2012 15:20, The Viper wrote:
> other ways for shortening the formula
> =IF(A2=FALSE,B2,A2)
> or
> =SUBSTITUTE(A2&B2,"FALSE","")
>
>
> On Mon, Dec 10, 2012 at 10:28 AM, Anoop K Sharma
> wrote:
>
>> Hi Dhaval,
>>
>> PFA...
>>
>> Regards
can any one please...
Need a macro to 5 workbook data to paste in single workbook, on one by one
in the same sheet
On Mon, Dec 10, 2012 at 12:05 AM, Puttu * wrote:
> SOME ONE HELP ME PLS
>
>
> On Sun, Dec 9, 2012 at 4:42 PM, Puttu * wrote:
>
>> Yogananda thanks for your prompt response
other ways for shortening the formula
=IF(A2=FALSE,B2,A2)
or
=SUBSTITUTE(A2&B2,"FALSE","")
On Mon, Dec 10, 2012 at 10:28 AM, Anoop K Sharma wrote:
> Hi Dhaval,
>
> PFA...
>
> Regards,
> Anoop
> Sr. Developer
>
>
> On Mon, Dec 10, 2012 at 9:12 AM, Dhaval Shah wrote:
>
>>
>> --
>> Join of
Use Query Table in macro which allow you to fetch complete table by macro.
Regards,
Anoop
On Sat, Dec 8, 2012 at 11:44 PM, Indrajit $nai wrote:
> Hi All,
>
> I wanna import / export webpage content through macro, if it is possible
> through VBA coding then plz provide me the VBA code.
>
> Kindl
Hi Dhaval,
PFA...
Regards,
Anoop
Sr. Developer
On Mon, Dec 10, 2012 at 9:12 AM, Dhaval Shah wrote:
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answere
Hi Amar,
Is this you want?
=IF(B2>$A$2,"↓",IF(B2<$A$2,"↑","↔"))
You can go to insert symbol section where you can put all of your choice
available there.
Regards,
Anoop
Sr. Developer
On Sat, Dec 8, 2012 at 10:23 AM, amar takale wrote:
> Hi Anoop
> Thanks very much for solution but I want neu
i=1
say
"Well done Paul"
while i
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick
SOME ONE HELP ME PLS
On Sun, Dec 9, 2012 at 4:42 PM, Puttu * wrote:
> Yogananda thanks for your prompt response.
>
> My requiements is below
>
> 1. I have more than 5-10 work book in the folder
> 2. Macro should open one workbook and copy the data and past it new
> workbook called as master
Hi Satyas,
Sorry for delay,
Please find attachment.
regards
prince
On Sunday, December 9, 2012 9:01:01 PM UTC+5:30, satyas wrote:
>
> Hello,
>
> Somebody please let me know is there any solution for this or not.
>
> On Friday, December 7, 2012 4:06:27 AM UTC+5:30, satyas wrote:
>>
>> Need to c
try the attachment see if it helps
On Fri, Dec 7, 2012 at 4:06 AM, satyas wrote:
> Need to create a summary sheet for the attached Excel doc.
>
> Tab “Detailed” is the input tab and works fine.
>
> Tab “Summary” should show the name from the A column in “Detailed” in any
> cell that correspond
Hello,
Somebody please let me know is there any solution for this or not.
On Friday, December 7, 2012 4:06:27 AM UTC+5:30, satyas wrote:
>
> Need to create a summary sheet for the attached Excel doc.
>
> Tab “Detailed” is the input tab and works fine.
>
> Tab “Summary” should show the name from
2012/12/9, sanjaykumarmanda...@gmail.com :
> Dear all,
>
> Please find the attachment my Query.
>
> Regards,
>
> Sanjay Mandal
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles,
18 matches
Mail list logo
