can you attach sample sheet to make work simpler..
Cheers!!
On Sat, Jul 19, 2014 at 12:03 PM, VETRI S P wrote:
>
>
> Sir,
>
>
> I have two Excel sheets in which one is Master Data Sheet other one is
> Normaldatasheet ( here data of two is same but all the data from Master
> data have to updat
Sir,
I have two Excel sheets in which one is Master Data Sheet other one is
Normaldatasheet ( here data of two is same but all the data from Master
data have to updated in NormalDatasheet)
*Criteria*
Fields in two Sheets
1. ServiceNo(datatype-Number)
2. PolicyNo(PrimaryKey, Alp
Maybe the trick would be to implement some sort of "delay" to allow it to
load properly.
On Wednesday, July 16, 2014 11:00:10 PM UTC-4, pramodb35 wrote:
>
> Hi Bill,
>
> The website is so heavy so it is taking lot of time to load .I am also
> working on it from another method.
>
> Regar
I sent someone an EXCEL macro enabled workbook file (created in EXCEL 2010)
and they ran some macros, saved the result, then later tried to run a
different macro and got the error message in the subject line. I had no
such problem in running it just the way they did it on my computer. It is
Not sure if it's better, but certainly fractionally simpler
=IF(E6="Model",INDEX($A$2:$A$11,COUNTIF($E$6:E6,E6)),"")
On Fri, Jul 18, 2014 at 1:45 PM, Nitya wrote:
> Thanks experts,
>
> I made it: =IF(E6="Model",INDEX($A$2:$A$11,COUNTIF($E$5:E5,E6)+1),"")
>
> if you have any better formula th
Cheers!!
On Fri, Jul 18, 2014 at 9:09 PM, renuka chari wrote:
> Thanks alot sir
>
>
> On Friday, 18 July 2014 14:00:05 UTC+5:30, Vabz wrote:
>
>> Hi
>>
>> PFA
>>
>> Cheers!!
>>
>>
>> On Fri, Jul 18, 2014 at 9:27 AM, renuka chari wrote:
>>
>>> Dear sir,
>>> i was prepared a macro for a
Thanks alot sir
On Friday, 18 July 2014 14:00:05 UTC+5:30, Vabz wrote:
>
> Hi
>
> PFA
>
> Cheers!!
>
>
> On Fri, Jul 18, 2014 at 9:27 AM, renuka chari > wrote:
>
>> Dear sir,
>> i was prepared a macro for autofilter the range based on column a1 in
>> unique values and
>> paste this rang
This seems to have nothing to do with currency.
it's simply a number.
ANY number can be displayed in any way you wish.
Simply right-click on the cell and select "Format Cells".
then,
If you want the $, then you can select "Currency"
If you simply want it to be numeric, select "Custom" and one
Cheers. .
On Jul 18, 2014 4:50 PM, "Ahmed Emam" wrote:
> Thanks for your support
>
>
> On Fri, Jul 18, 2014 at 9:40 AM, Vaibhav Joshi wrote:
>
>> Hi
>>
>> Check conditional format set in sheet..
>>
>> First select Cell A1, then conditional formting and Manage Rules...
>>
>> Cheers!!
>>
>>
>>
>>
Thanks for your support
On Fri, Jul 18, 2014 at 9:40 AM, Vaibhav Joshi wrote:
> Hi
>
> Check conditional format set in sheet..
>
> First select Cell A1, then conditional formting and Manage Rules...
>
> Cheers!!
>
>
>
>
> On Fri, Jul 18, 2014 at 12:51 AM, Ahmed Emam wrote:
>
>> That' what i me
If it doesn't work then you need to change your regional settings of
Windows!!
Goto Control panel, Select Regional & Language, in format Tab select
Additional settings,
Select currency tab, goto digital grouping & select second option from top
with coma after 3rd digit.
Cheers!!
On Fri, Jul 1
try below
[>=1000]$ ##\,##\,##\,##0;[>=10] ##\,##\,##0;##,##0
.
Enjoy
Team XLS
On Fri, Jul 18, 2014 at 2:32 PM, Rohan Young wrote:
> *Hi Experts*
>
> * how do get US$ currency format from 1234567 to 1,234,567*
>
> thanks
>
> --
> Are you =EXP(E:RT) or =NOT(EX
try this .. only formula used nothing else
.
Enjoy
Team XLS
On Fri, Jul 18, 2014 at 10:30 AM, my excel wrote:
> Sir,
> i sent attached file of my friend ration shop
> & pls see out put data
> he wanted a macro to generate output data
> pls help
>
>
> regards:
> Veeren
*Hi Experts*
* how do get US$ currency format from 1234567 to 1,234,567*
thanks
--
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, ac
Hi
PFA
Cheers!!
On Fri, Jul 18, 2014 at 9:27 AM, renuka chari wrote:
> Dear sir,
> i was prepared a macro for autofilter the range based on column a1 in
> unique values and
> paste this range into sheet2 side by side
> in this i have succed in the autofilter the range data but failed to copy
Thanks experts,
I made it: =IF(E6="Model",INDEX($A$2:$A$11,COUNTIF($E$5:E5,E6)+1),"")
if you have any better formula than please please share me.
On Fri, Jul 18, 2014 at 12:59 PM, Nitya wrote:
> Hi experts,
>
> I want to write a formula like wise : Where ever there is "Model" word,
> next t
Hi experts,
I want to write a formula like wise : Where ever there is "Model" word,
next to "Model", the Part list should list accordingly in sequence. I have
attached in details.
I am struggling in writing formula. Please help.
Regards,
Nitya
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exce
17 matches
Mail list logo
