Dear all
Can Anybody tell me formula to merge cell entry in one column if it is
duplicate then over right on it
Regards
Amar
--
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
Hi expersts,
I am trying to run the attached macro to get price of a bond. Please assist
me get to know what i am doing wrong. Its not giving me any value, did i
miss a step?
Regards,
Boreh
On 11 December 2012 15:00, Robinson Boreh wrote:
> Hi Prince,
> Thanks for your feedback.
> Attached is
pls provid the sample data.
Regards,
Gawli Anil
On Thu, Dec 13, 2012 at 12:10 PM, SHAIL GROUPS wrote:
> Respected sir,
>i want to use pivort table in multi sheet of excel
> 2007
>
>
>
>
>
> --
>
> *[image: i love you]*
>
> **
>
> **[image: -][image: -][image: -][image: -]
Respected sir,
i want to use pivort table in multi sheet of excel
2007
--
*[image: i love you]*
**
**[image: -][image: -][image: -][image: -][image: -]
**
*"No Gain WithoutPain"*
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
Hi Sandeep,
whenever we copy any data from any source we are not sure about the spaces
into the value. So i feel there may be the data item that you want not
duplicate contain any space and making it another explicit value.
So for avoiding above problem use "Trim()" fuction to remove the space
Dear Excel guru,
I have tried this data validation to stop duplicate entry as well as :
=and(countif($e$3:$e$500,e3)=1,len(e3)=15)
Though when some is making manual entry its working fine but it stops working
if someone copy from above or somewhere else.
Can I do something to stop this!!
Pleas
Hi Paul,
is the reason one would divide by 7 is because there is 7 days in a week?
Susan
On Thursday, December 6, 2012 7:58:00 AM UTC-8, Paul Schreiner wrote:
>
> WEEKS is easy.
> Keep in mind that Excel "dates" are simply numbers.
> The number of days since 1/1/1900.
>
> You can use =TODAY() t
Hi Prince
I got my final solution. If you wish you can go through the excel sheet, so
that you can come to know what I was looking for.
Thanks for your support and help.
On 12 December 2012 14:25, Prince wrote:
> Hi Satyas.
>
> I feel if there is more then one person exist on the same slot on
To be more specific.
In this case I want to query the S&P 500 every minute between 09:00 and
16:30.
Thanks for all your input.
On Wednesday, December 12, 2012 10:09:26 AM UTC-5, Bill Q wrote:
> From what I can see, it looks like this will interfere with the
> runintervalminutes (whic
Good Afternoon,
I am trying to find a way to do conditional functions based on multiple
criteria and I can't seem to find a way to do this.
*What I have:*
Multiple columns of information: ID, Day of week, Week of, and Start
Date/time, End day/time
*What I would like:*
I'd like to subtract the
>From what I can see, it looks like this will interfere with the
runintervalminutes (which is important to be seperate). Also, how to I get
it to stop at a specific time ?
On Wednesday, December 12, 2012 2:44:15 AM UTC-5, Enrique Martin wrote:
> Hi Bill,
>
> There are two variable defined
if I M PUTTING MORE DATA ABOVE 808 ROW AND CHANGE THE DATA RANGE IT CANT
WORK
On Wednesday, December 5, 2012 11:14:29 PM UTC+5:30, Excel Beginner wrote:
>
> Hi Dhaval,
>
>Please find the attachment.
>
>
>
>
>
>
> --
> *Regards,*
> *
> *
> *Excel Beginner*
> *
> *
> On Wed, Dec 5,
Already change data range but not working
On Wed, Dec 12, 2012 at 6:24 PM, Satendra kumar
wrote:
> Hi,
>
> change data range than apply i hope this is working...
>
> thankx
> satendra
>
>
> On Wed, Dec 12, 2012 at 6:19 PM, Dhaval Shah wrote:
>
>> FRIENDS
>>
>> WHENEVER I M PUTTING NEW DATEA A
Hi,
change data range than apply i hope this is working...
thankx
satendra
On Wed, Dec 12, 2012 at 6:19 PM, Dhaval Shah wrote:
> FRIENDS
>
> WHENEVER I M PUTTING NEW DATEA ABOVE 808 UPTO 5000 RAW FORMULA NOT WORKING
>
> --
> Join official Facebook page of this forum @
> https://www.faceb
Hi Friend,
Instead of adding all cells just Paste below formula in AE5 and Drag the
same upto AE25 .
Formula Is : =SUMPRODUCT(($C$4:$AD$4),($C5:$AD5))
Regards
Prince
On Monday, December 10, 2012 12:31:47 PM UTC+5:30, excel lerner wrote:
>
> Sir
>
> Please see the sample and help me.In this fi
Nice approch viper:)
Prince
On Tuesday, December 11, 2012 10:40:17 AM UTC+5:30, §»VIPER«§ wrote:
>
> another approach
> works even if dates are not sorted
> pfa
>
> On Tue, Dec 11, 2012 at 10:21 AM, Pravin Gunjal
> > wrote:
>
>> *Good one. Thanks Anoop.*
>>
>> -- Forwarded message -
RunWhen = TimeSerial(15, 0, 0).
On Wed, Dec 12, 2012 at 2:38 PM, Anoop K Sharma wrote:
> Hi Bill,
>
> Please see below. The RunWhen variable must be as below:
>
> RunWhen = Now + TimeSerial(15, 0, 0).
>
>
> On Wed, Dec 12, 2012 at 1:14 PM, Anoop K Sharma wrote:
>
>> Hi Bill,
>>
>> There are two
Hi Bill,
Please see below. The RunWhen variable must be as below:
RunWhen = Now + TimeSerial(15, 0, 0).
On Wed, Dec 12, 2012 at 1:14 PM, Anoop K Sharma wrote:
> Hi Bill,
>
> There are two variable defined in your module. These are "RunWhen" and
> "SaveWhen".
> Both of them are being used with t
Thanks sir
On Wed, Dec 12, 2012 at 1:49 PM, Sayed Abdul Azeem (QFD) wrote:
> Dear neeraj chauhan
>
> ** **
>
> ** **
>
> ** **
>
> I hope this will help you.
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> Regards
>
> ** **
>
> *Syed Azeem*
>
> ** **
>
> ** **
>
> **
Hi Satyas.
I feel if there is more then one person exist on the same slot on the same
booth how will you represent them in a single cell.
Can you please give a small idea or some example of how your final result
will appear.
Regards
Prince
On Wednesday, December 12, 2012 2:28:26 AM UTC+5:30, s
Hi Amar,
please paste this Cell i8 and press Ctrl+Shift+Enter
Regards
Prince
On Tuesday, December 11, 2012 1:13:52 PM UTC+5:30, amar takale wrote:
>
> Hi All Champs
>
> I will Request all anyone suggest me unique value from same month (formula)
>
> Regards
> Amar
>
>
>
--
Join official Faceboo
Hi Neeraj,
Do the fallowing steps:
1:select B2 cell
2:Go to Conditional formatting click manage rules click on New Rules
3:Select Rules type [use formula to determine which cell to format ]
4:In edit Rule description Type or write : =B2>1
5:Click on format ->Select Fill -> Choose any color ->c
Dear neeraj chauhan
I hope this will help you.
Regards
Syed Azeem
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of neeraj chauhan
Sent: Wednesday, December 12, 2012 10:59 AM
To: excel-macros@googlegroups.com
Subjec
23 matches
Mail list logo
