>
> Dear All, when I entered 16th digit in excel excel automatically shows it
> zero. I need enter 16 or 17 digit in single cell. Plz guide how to fix this
> issue.
--
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
--
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, like Please Help,
Urgent, Need Help, F
Dear All, hope u are all is well...please help me about caption. How to
Plot cut in Y axix in scater chart
--
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
Dearn All,
How to put range (1-99, 100-199, 200-299 so on) in scattar chart x
axis
--
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) U
My Dear How to make calculater with excel..with Vb or with out Vb.
--
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
Dear All Hope you're all well...my problem is my one excel work book's
formulas not updated automatically. Again and again I do press F2+Enter on
any single cell. I have already used check formula+ calculation option +
automatic option but no any advantage of its on and off.
--
Are you =EXP(E:RT)
Dear All, Hope all of you are well. I need for a formula which can generate
codes series automatically. Like I have a code series 1040004500 when I
have press TAB then the series code like that 1040004600..mean 45
convert into 46.
On May 31, 2015 9:45 PM, "Ali Abbas" wrote:
orrect
> me or explain your query in more details.
>
> Regards,
> MandeepBaluja
> Learningzmypassion.
> https://www.facebook.com/groups/825221420889809/
> https://www.linkedin.com/profile/view?id=312532939
>
>
>
> On Sunday, May 31, 2015 at 10:15:11 PM UTC+5:30, ali abba
Dear All,
Hope all of you are well. I need for a formula which can generate codes
series automatically. Like I have a code series 1040004500 when I have
press TAB then the series code like that 1040004600..mean 45 convert
into 46.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And d
Thank very much Ganesh Problem Solve
On May 14, 2015 4:14 PM, "Ganesh N" wrote:
> HI abbas,
>
> Use the conditional formatting with "Use a formula to determine which
> cells to format'
>
> Regards,
> Ganesh N
>
> On Thu, May 14, 2015 at 3:24 PM, Ali
Dear All. Hope u r all well.
I have two column with numbers. My requirement is if one column values is
greater than other then greater values color should be red and its smaller
values color is green. How can I compare two columns by using of
conditional.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)
-- Forwarded message --
From: "Dan Burfield"
Date: Dec 4, 2013 3:06 PM
Subject: $$Excel-Macros$$ need help with nested IF AND formula
To:
Cc:
Hi, thx in advance for your help. I am trying to build a spreadsheet that
will help calculate medication doses. The variables involved are
t blank rows (From row 2001 to
> 4000).
> 4. Repeat paste from row 4001 to 6000.
> 5. Sort on the number column. It will put is as 1,1,1 then 2,2,2 and so on.
> 6. The first 1 will have your data and the other two will be blank rows.
> 7. Delete the number column.
>
> HTH
>
>
Dear All I have data in balk near to 2000 rows now I need to insert 2 rows
after every rows if I am done this manual this is big problem and time
wasting plz guide how cam I. Done this by macro or with any other way.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
Dear all, how can we control Filter with the help of macro bottons.
--
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
Thanks my dear thank you very much.
On Nov 28, 2013 12:33 PM, "Ashish Kumar" wrote:
> Hi Ali Abbas,
>
> Press ALT + F11 for Go to the VBA Application, then click on Tool, after
> that click on VBA Project Properties, then click on protection and put your
> passward
Thanks my dearcan we protect this hidden sheet with passward.?
--
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 t
ou select the worksheet from VBA project and then
> choose your dropdown option.
>
>
> Regards,
> Vasim Shaikh
>
> On Thursday, November 28, 2013 4:35:25 PM UTC+5:30, ali abbas wrote:
>>
>> my dear when I am use this option than a error comesunable to set
>
sday, November 28, 2013 4:35:25 PM UTC+5:30, ali abbas wrote:
>>
>> my dear when I am use this option than a error comesunable to set
>> visible properties of the worksheet class...now what I am doing plz help
>> On Nov 28, 2013 10:57 AM, "Ali Abbas" wro
my dear when I am use this option than a error comesunable to set
visible properties of the worksheet class...now what I am doing plz help
On Nov 28, 2013 10:57 AM, "Ali Abbas" wrote:
> Thaks
> On Nov 28, 2013 10:39 AM, "Shaikh Vasim" wrote:
>
>> Okies
Thaks
On Nov 28, 2013 10:39 AM, "Shaikh Vasim" wrote:
> Okies,
>
>
> Go to Developer - Visual Basic - Select the sheet (you want ro hide from
> the VBA project box)
> in VBA editor - View - Properties window
> in Properties window box - Visible (last option) and change it from
> dropdown to optio
Thank You Very Much.
On Nov 28, 2013 10:39 AM, "Shaikh Vasim" wrote:
> Okies,
>
>
> Go to Developer - Visual Basic - Select the sheet (you want ro hide from
> the VBA project box)
> in VBA editor - View - Properties window
> in Properties window box - Visible (last option) and change it from
> dr
Dear All,
Hope all you well...plz tell me how can we hide excel sheet permanently
which no buddy can un-hide, amd how can we hide xl sheet which no buddy
can see with unhide option.
Thank Tigarman007.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:
Ok boss I will share the file with you but I cannot use the Pivot Table
in this my work situation.
On Nov 4, 2013 3:15 PM, "ashish koul" wrote:
> why don't u use pivot table also can u share a sample file
>
>
> On Mon, Nov 4, 2013 at 8:33 PM, Ali Abbas wrote:
I need a maximum array formula which can calculate maximum value in a
single column, but any unique value repeated again and again in the column.
Need is if "a" comes 5 times ,"b" comes 7 times than this formula calculate
highest value of "a" and "b"which are in single column. Plz plz
--
Are you
On Nov 2, 2013 9:03 AM, "Ali Abbas" wrote:
> Dear All, How can we develop a Formula for calculate max number in unique
> values like if we have 1000 total values and 10 values are unique in this
> data. I have needed a single formula which can calculate unique values max
>
Dear All, How can we develop a Formula for calculate max number in unique
values like if we have 1000 total values and 10 values are unique in this
data. I have needed a single formula which can calculate unique values max
number (problem is all 1000 values in a single column and their number in
ot
dear sir formula not work plz help.
On Aug 22, 2013 5:34 PM, "Ali Abbas" wrote:
> thanks brother
> On Aug 22, 2013 4:14 PM, wrote:
>
>> **
>> You can use sumproduct also
>>
>> =sumproduct(--(and((a:a)>=c1,(a:a)<=c2),b:b)
>>
>> Assumin
gt; Sandeep
> Sent on my BlackBerry® from Vodafone
> ------
> *From: * Ali Abbas
> *Sender: * excel-macros@googlegroups.com
> *Date: *Thu, 22 Aug 2013 23:31:14 +0800
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *$$Excel-Macro
Date: 1 2 3 4
Amount: 100 200 300 400
Now formula working.
We can calculate value with array sum amount if date 1 to 3 then answer is
600 but if we change date scenario and mention date in cut day like sum
amount if date is 2 to 4 then its answer will be 900 but how can I make
th
Dear all. How can we calculate a array function for sum amount or any
figure for cut dates like sum if( 12 feb to 20 feb)
--
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/discu
thanks my dear, May Allah Bless On You.
On May 23, 2013 10:57 AM, "Prabhu Pinky" wrote:
> Hi,
>
> try the key combinations* Alt+H+M+U* to Unmerge and *Alt+H+M+M* to Merge
> the cells.
>
>
> Regards
> Prabhu R
>
> On 23 May 2013 15:28, Ali Abbas wrote:
&
Dear All, any one know how can we un-merge cells in excel with short keys
Or have a any short keys for unmerge to cells
--
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/discuss
33 matches
Mail list logo
