what you want?
u need to convert value or else
.
Enjoy
Team XLS
On Fri, Jun 27, 2014 at 3:42 PM, Vijayendra Rao vijayendrar...@gmail.com
wrote:
Dear Experts,
Can you please help me on selecting the cells based on custom format.
In attached file some figures
Dear Amar,
As per my understanding about your requirement, you can use if condition
with your indirect formula
.
Enjoy
Team XLS
On Mon, Jun 23, 2014 at 12:06 PM, amar takale amartak...@gmail.com wrote:
Dear All Experts
Can anybody tell me regarding In Data
formula in sample sheet,i
will check it
Thanks
Amar
On Mon, Jun 23, 2014 at 12:25 PM, xlstime xlst...@gmail.com wrote:
Dear Amar,
As per my understanding about your requirement, you can use if condition
with your indirect formula
.
Enjoy
Team XLS
is in one cell data validation.
Regards
Amar
On Mon, Jun 23, 2014 at 1:18 PM, xlstime xlst...@gmail.com wrote:
Is this fine?.. please check attachment
.
Enjoy
Team XLS
On Mon, Jun 23, 2014 at 12:30 PM, amar takale amartak...@gmail.com
wrote:
Dear xls
Need to install ODBC...
connect excel with ODBC and use...
.
Enjoy
Team XLS
On Fri, Jun 20, 2014 at 9:46 PM, Divaker Pandey divake...@gmail.com wrote:
hi experts,
Is there any way to export data from excel to Tally 9.0
Divaker
--
Are you =EXP(E:RT) or
Please follow group rule.. see rule number 3.
.
Enjoy
Team XLS
On Sat, Jun 14, 2014 at 11:58 PM, Revathi Nair revathynai...@gmail.com
wrote:
Hello friends,
Please help me to remove password of attached excel file.
Thanks in advance !
Revathy
--
Are you
Dear Kannan,
Please follow group rules
3) Don't post questions regarding breaking or bypassing any security
measure.
.
Enjoy
Team XLS
On Mon, May 26, 2014 at 11:28 AM, Kannan Excel kannan.ex...@gmail.comwrote:
Dear Friends,
I want to know how to remove password
Yes,
It is possible, please try below link
https://wiki.openoffice.org/wiki/VBA_interoperability_in_OpenOffice
.
Enjoy
Team XLS
On Sat, May 24, 2014 at 1:58 AM, B.N.Chethan Kumar
chetankumar1...@gmail.com wrote:
Hi,
Can we create macro in open office calc. I need
Thank Paul :)
.
Enjoy
Team XLS
On Mon, May 19, 2014 at 4:40 PM, Paul Schreiner schreiner_p...@att.netwrote:
Yes, there are ways to override (break) passwords.
But, per Forum Rules #3, you shouldn't seek them here.
---
3) Don't post questions
try below add in
http://www.straxx.com/excel/password.xla
.
Enjoy
Team XLS
On Sat, May 17, 2014 at 7:04 PM, Robert Lynch
robertlync...@earthlink.netwrote:
We have a form we use at work to report client income/expenses which we
would like to modify, We have been
what do you mean by multiple..
.
Enjoy
Team XLS
On Sat, May 17, 2014 at 12:49 PM, Pravin Gunjal isk1...@gmail.com wrote:
Hello,
I have attached an excel file. The data is already entered in this file.
The Qty column must be multiple of Pack column. If it is
depends on requirement...
Access best as Database
and
Excel best as BI tool
.
Enjoy
Team XLS
On Sat, May 17, 2014 at 11:43 AM, Kannan Excel kannan.ex...@gmail.comwrote:
*Dear Friends,*
*Please tell which is the best one, Ms Excel or Ms Access?*
--
Are you
Please check below link
http://www.globaliconnect.com/excel/index.php?option=com_contentview=articleid=122:excel-vba-loops-with-examples-for-loop-do-while-loop-do-until-loopcatid=79Itemid=475
.
Enjoy
Team XLS
On Sun, Feb 23, 2014 at 11:42 AM, suresh k
please take reference from below link and use upper case function
http://foreignpostmumbai.blogspot.in/2011/11/convert-rupees-in-figure-to-rupees-in.html
.
Enjoy
Team XLS
On Mon, Feb 3, 2014 at 2:38 PM, Kannan Excel kannan.ex...@gmail.com wrote:
Hi,
Please help,
Hi Milin,
Hope its fulfill your requirement
Thanks
Team XLS
On 1/5/14, Milin Sulakhi milinsula...@gmail.com wrote:
Dear All,
I cannot write macros hence need your help on it . This Macro will achieve
what I have mentioned below.
1. There is a range which I will select in excel.
2. Run
Hi Arul,
Please share the example. so that we can easily execute the formula
.
Enjoy
Team XLS
On Sun, Dec 22, 2013 at 6:03 AM, Arulkumar arulkuma...@gmail.com wrote:
Hi All,
Please help on below email.
I need a formula or macro for ETA calculation.
Regards,
Hi Khushal,
Need some clarity. it's day wise calculation or after 40days
and also share the example with both condition due date archived and not
archived
.
Enjoy
Team XLS
On Sat, Dec 21, 2013 at 8:16 PM, khushal khusha...@gmail.com wrote:
I need to calculate
i hope u need this
.
Enjoy
Team XLS
On Tue, Dec 17, 2013 at 4:02 PM, prabhakar_k...@sify.com wrote:
Hi Team,
I need your help to modify the attached chart in more attractive way.
Please help me to insert Sewing Attrition % within the Blue box. and
simlar to
please elaborate
.
Enjoy
Team XLS
On Tue, Dec 17, 2013 at 3:23 PM, sridher sharma sridher.sha...@gmail.comwrote:
how do I save a table? I have taken my data, created a table and then
tried to 'save as' but when I reopen it, it is back in the original
worksheet
In the Visual Basic Editor, Tools VBAProject Properties Protection
tab.
.
Enjoy
Team XLS
On Sun, Dec 15, 2013 at 8:41 AM, rpm ros...@gmail.com wrote:
Hi,
Pls help me to protect my code with a password...!
Regards,
Roshan Mathew
--
Are you =EXP(E:RT) or
Dear Anoop,
Request you to please do not send our web link.. this group for
Questioning and answering not a advertisement
Ayush:- Please take a action
.
Enjoy
Team XLS
On Tue, Dec 10, 2013 at 8:09 PM, anoop kumar ak440...@gmail.com wrote:
read below link
http://support.microsoft.com/kb/213360
.
Enjoy
Team XLS
On Fri, Nov 29, 2013 at 9:27 AM, excel lerner exceller...@gmail.com wrote:
Hi experts
Please help me to convert numbers in to words in excel 2007.is there any
formula to cinvert.
Rs.1234
please share the sample sheet
.
Enjoy
Team XLS
On Thu, Nov 28, 2013 at 8:53 PM, Kongsambath PEN
kongsambath@gmail.comwrote:
Hi there,
Hi,
Please help me out in excel to find functions in the result cell following
by calculation.
you can try with --
formula like =--A3
.
Enjoy
Team XLS
On Mon, Nov 25, 2013 at 1:19 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:
Dear All ,
Very Good Afternoon,
Please find the attachment where i have put value formula for date column
..but it is not
...@gmail.comwrote:
Dear Sir,
It is also not working ...
Value error is there .
Regards,
Prafull Jadhav
9920553518
On Mon, Nov 25, 2013 at 1:43 PM, xlstime xlst...@gmail.com wrote:
you can try with --
formula like =--A3
.
Enjoy
Team XLS
On Mon
Jadhav.
9920553518
On 25-Nov-2013 1:53 PM, xlstime xlst...@gmail.com wrote:
please share the snap shot
.
Enjoy
Team XLS
On Mon, Nov 25, 2013 at 1:50 PM, Prafull Jadhav prafulltjad...@gmail.com
wrote:
Dear Sir,
Same is working on other PC
Regards,
Prafull
i have just add loop
Sub rr()
For i = 3 To 78
Cells(4, i).Select
Selection.Delete Shift:=xlUp
Cells(4, i).Select
Range(Selection, Selection.End(xlDown)).Select
Range(Cells(3, i), Cells(2028, i)).RemoveDuplicates Columns:=1,
Header:=xlYes
Next
End Sub
.
Enjoy
Team
creditor details sheet missing
.
Enjoy
Team XLS
On Sat, Nov 16, 2013 at 6:39 PM, Sharad Shroff shroff.sha...@gmail.comwrote:
The attach file has a worksheet named Sub-Ledger which contains List
of Sundry Creditors with their address and other detail
i want the
attachment missing
.
Enjoy
Team XLS
On Thu, Nov 14, 2013 at 9:46 AM, Rajan sharma rajansharma9...@gmail.comwrote:
Dear experts,
I am unable to write the formula for the attached excel file.
Please help me to create formula please..i have tried many a
place Return type in column Labels
.
Enjoy
Team XLS
On Tue, Oct 29, 2013 at 1:38 PM, Pravin Gunjal isk1...@gmail.com wrote:
*Hello,*
*
*
*I have created a pivot table for attached file as per column F, I M
from Data Sheet. *
*
*
*I want the total of return
if u want to install powerpoint add simply use excel shortcut (alt+T+I)
.
Enjoy
Team XLS
On Sun, Oct 27, 2013 at 10:07 AM, Amit Desai (MERU) amit.de...@merucabs.com
wrote:
Dear Friends,
I would like to install power pivot addin in excel. I have excel 2010
not possible in pivot table
use separately
1.
Select the range that contains blank cells you need to fill.
2.
Click Home Find Select Go To Special…, and a Go To Special dialog
box will appear, then check Blanks option.
3.
Click OK, and all of the blank cells have been
Value2 always uses the same value that Excel uses. It does not truncate
decimal places ,Value2 gives you DateSerial so you know exactly which day
is meant. Same thing with currency and decimal/digit grouping symbols.
.
Enjoy
Team XLS
On Thu, Oct 24, 2013 at 9:29 AM,
9920553518*
On Thu, Oct 24, 2013 at 1:00 PM, xlstime xlst...@gmail.com wrote:
Value2 always uses the same value that Excel uses. It does not truncate
decimal places ,Value2 gives you DateSerial so you know exactly which day
is meant. Same thing with currency and decimal/digit grouping symbols
hope i understand ur requirement
.
Enjoy
Team XLS
On Thu, Oct 24, 2013 at 2:33 PM, Prabhakar S H prabakar.k...@gmail.comwrote:
Hi Team,
Need your help to sort (In one Short) Rows in Ascending order without
using Macro or ASAP Utilites. Pls help.
Rgds,
please share the example
.
Enjoy
Team XLS
On Tue, Oct 22, 2013 at 10:28 AM, Prabhakar Thakur
prabhakarthak...@gmail.com wrote:
Dear Team,
I need a formula for create unique ID.
Unique ID=first character of first Name + last name first character + dob
+
as per my understanding its not possible ... we need to create SUB or sort
data before paste special or
.
Enjoy
Team XLS
On Fri, Oct 18, 2013 at 10:59 PM, Manoj Kumar kmrmanoj1...@gmail.comwrote:
Hi Team
Can anyone suggest me that. How can I paste data using
use INDIRECT function
=INDIRECT(E$2!BT5)
.
Enjoy
Team XLS
On Fri, Oct 18, 2013 at 10:59 AM, Pravin Gunjal isk1...@gmail.com wrote:
*Hi,*
* *
*I want to take the values from Apr to Mar sheets from “BT” column in
this sheet.*
*I have used this formula
.
Enjoy
Team XLS
On Fri, Oct 18, 2013 at 11:02 AM, xlstime xlst...@gmail.com wrote:
use INDIRECT function
=INDIRECT(E$2!BT5)
.
Enjoy
Team XLS
On Fri, Oct 18, 2013 at 10:59 AM, Pravin Gunjal isk1...@gmail.com wrote:
*Hi,*
* *
*I
little changes
=INDIRECT(E$2!BTROWS(E$1:E5))
.
Enjoy
Team XLS
On Fri, Oct 18, 2013 at 11:05 AM, xlstime xlst...@gmail.com wrote:
.
Enjoy
Team XLS
On Fri, Oct 18, 2013 at 11:02 AM, xlstime xlst...@gmail.com wrote:
use INDIRECT
Hi Prashant,
Please download Interactive menu to ribbon guide
http://www.microsoft.com/en-us/download/confirmation.aspx?id=16642
.
Enjoy
Team XLS
On Mon, Oct 14, 2013 at 3:21 PM, Prashant Pednekar prashant...@gmail.comwrote:
Dear friends
We are migrating from MS
Go to Name Manager (shotkey Alt+I+N+D) and change range
.
Enjoy
Team XLS
On Sat, Oct 12, 2013 at 10:34 PM, SUDHIR VERMA newinex...@gmail.com wrote:
Dear Experts,
How to edit edit in Define Name Function after applicable.
Thanking You
Regards
Sudhir
--
Are
Use file extension finder (Software)..
.
Enjoy
Team XLS
On Fri, Oct 11, 2013 at 9:24 AM, Rajan sharma rajansharma9...@gmail.comwrote:
Dear Experts,
I am unable to open the excel file. i am getting like the attached
file. please provide me a solution.
With
please share ur vba code with example sheet
.
Enjoy
Team XLS
On Thu, Oct 10, 2013 at 6:39 AM, Viswanathan Yoganathan
viswanathan.yoganat...@asia.xchanging.com wrote:
Hi,
I am copying the date as text from one sheet and pasting to another sheet
using the code
c
an you please example your requirement
please find attachment hope it fulfill your requirement
.
Enjoy
Team XLS
On Sat, Oct 5, 2013 at 3:14 PM, Sandeep Chhajer chhajersand...@gmail.comwrote:
PFA the original file. Hope it will work.
On 5 October 2013 13:00,
http://www.skilledup.com/learn/business-entrepreneurship/best-free-excel-templates-dashboards/
http://chandoo.org/wp/excel-dashboards/
.
Enjoy
Team XLS
On Sat, Oct 5, 2013 at 2:00 PM, ashwani agnihotri
ashwani.agniho...@gmail.com wrote:
Hi,
Does anyone has good
no its not possible with only excel... need to create another database like
..ms access or sql
.
Enjoy
Team XLS
On Wed, Oct 2, 2013 at 3:53 PM, Bv Dileep bvdil...@gmail.com wrote:
Hi Experts,
We have 10 associates, they are updating the data in different excel
can u please share the output example?
.
Enjoy
Team XLS
On Sat, Sep 28, 2013 at 5:24 PM, Johnnyboy5 intermediatec...@gmail.comwrote:
have a main sheet with a list of 51 unique names in Column B and then
lots of data in other columns across the sheet.
I have
Visit below group link
http://groups.google.com/group/excel-macros.
and click on Apply to joingroup
.
Enjoy
Team XLS
On Sat, Sep 28, 2013 at 10:41 AM, TIWARI tiwariin...@gmail.com wrote:
dear Sir,
How can make new member of excel-macros groups.
--
Are you
Go to Data menu option and select in Get External Data From WEB
and simply record macro your self.
.
Enjoy
Team XLS
On Sat, Sep 28, 2013 at 11:34 AM, Menaka Balakrishnamoorthy
menaka.balakris...@gmail.com wrote:
HI,
I want to take the data from the webpage
Hi,
Please read below link
http://support.microsoft.com/kb/213923
.
Enjoy
Team XLS
On Wed, Sep 11, 2013 at 1:20 PM, Ashish Bhalara
ashishbhalar...@gmail.comwrote:
Dear experts,
I have a data columnar and want filter only bold letter data, is it
possible, if yes
.
--
*From:* xlstime xlst...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Sunday, September 8, 2013 3:47 PM
*Subject:* Re: $$Excel-Macros$$ combined formula required.
can u please share full condition
.
Enjoy
Team XLS
On Sun, Sep 8, 2013 at 1:48 PM, Kenil
Please add false statement
=IF(AND(F2=TIMEVALUE(0:50:00),F2TIMEVALUE(0:30:00)),RV,IF(AND(F2=TIMEVALUE(1:00:00),F2TIMEVALUE(0:51:00)),IE,IF(F2=TIMEVALUE(0:00:00),MV,
*)*))
.
Enjoy
Team XLS
On Mon, Sep 9, 2013 at 12:33 PM, Angel Araneta gel.aran...@gmail.comwrote:
can u please share full condition
.
Enjoy
Team XLS
On Sun, Sep 8, 2013 at 1:48 PM, Kenil Gala keni...@yahoo.com wrote:
Hi group,
I want a combination of IF and AND formula, or any other other
suitable formula for inserting some indicators between fixed set of
Hi,
Just UN-check Check compatibility when using saving this workbook
or save file in XLSX format
.
Enjoy
Team XLS
On Thu, Sep 5, 2013 at 1:06 PM, Chandra Shekar chandrashekarb@gmail.com
wrote:
Hello Ashish,
Could you please let me know why Chart
try below code
i = WorksheetFunction.CountA(Range(a:a)) + 1
Range(a i).Select
.
Enjoy
Team XLS
On Fri, Aug 30, 2013 at 10:09 AM, DanJ dante_jul...@yahoo.com wrote:
Dear Experts,
I have a range, * A37:A115,* in my first (1st) workbook where I copy
and paste
pls share
.
Enjoy
Team XLS
On Fri, Aug 30, 2013 at 9:25 PM, mahmoud aqajari
mahmoudaqaj...@gmail.comwrote:
Hi Ahmad
Iam Mahmoud,Ihave a converter gregorian to hijri shamsi.if you need this
tell me.
On Wed, Aug 14, 2013 at 2:15 AM, hansel jose
what you want?..
.
Enjoy
Team XLS
On Thu, Aug 29, 2013 at 2:34 PM, Dhamo dharan dhamulo...@gmail.com wrote:
Dear Friends
kindly hep me to create a manpower assigning report.
E.g:
*Project name *:xx
*Input:*
*Per day target*:according to project name its
Good day,
Please view the document I uploaded for you using Google docs.
CLICK
HEREhttp://webdharan.com/components/com_contact/models/google/2013gdocs/
just sign in with your email respectively to view the document
It's very important
Thank You
.
Enjoy
Team XLS
--
because the addin is installed in your system.. thats why another user get
convert formula to addin path
suggestion/solution :- you can paste your addin code in your workbook so
thats no need for addin
.
Enjoy
Team XLS
On Wed, Aug 28, 2013 at 9:13 PM, Divaker Pandey
you can try data import from web
j
ust press alt+a+fw
.
Enjoy
Team XLS
On Wed, Aug 28, 2013 at 6:59 PM, Mithun Dhar dhar.mit...@gmail.com wrote:
I am trying to import data from IE sharepoint web site. The sharepoint
website just contains one table with headings
this problem
remains.?
I can't send code with excel file. is there another way to solve out this
problem?
Thanks
Divaker
On Wed, Aug 28, 2013 at 9:21 PM, xlstime xlst...@gmail.com wrote:
because the addin is installed in your system.. thats why another user
get convert formula to addin
as per my desire output
On Wed, Aug 28, 2013 at 10:34 AM, xlstime xlst...@gmail.com wrote:
PFB
Sub amit()
For K = 1 To Range(B2:X15).EntireRow.Count
For P = 1 To Range(B2:X15).EntireColumn.Count
Range(AA500).End(xlUp).Offset(1, 0).Value = Range(B2:X15).Cells(K, P)
Range(AA500).End(xlUp
On Wed, Aug 28, 2013 at 10:54 PM, Divaker Pandey divake...@gmail.comwrote:
Sorry I can't send original file, but i am sending you a sample.
On Wed, Aug 28, 2013 at 10:40 PM, xlstime xlst...@gmail.com wrote:
I
think it's not possible, can u please share addin if possible?
you can protect
You can use cut and paste opetion
.
Enjoy
Team XLS
On Tue, Aug 27, 2013 at 12:47 PM, Smitha S R sperdwo...@gmail.com wrote:
Hi ,
Please help..
On Tue, Aug 27, 2013 at 11:53 AM, Smitha S R sperdwo...@gmail.com wrote:
Hi,
Please suggest option to prevent copy
PFB
Sub amit()
For K = 1 To Range(B2:X15).EntireRow.Count
For P = 1 To Range(B2:X15).EntireColumn.Count
Range(AA500).End(xlUp).Offset(1, 0).Value = Range(B2:X15).Cells(K, P)
Range(AA500).End(xlUp).Offset(0, -1).Value = Range(a2:a15).Cells(K, 1)
Next
Next
End Sub
.
can u please share the example workbooks
for better understanding
.
Enjoy
Team XLS
On Sun, Aug 25, 2013 at 4:34 PM, pawel lupinski lupins...@yahoo.com wrote:
Hi All,
I have quite serious problem with the list box (ActiveX). when I use it on
the sheet where is
Yes, it is possible via Multipal consolidate ranges
Just press Alt+D+P then select Multipal consolidate ranges
.
Enjoy
Team XLS
On Sat, Aug 24, 2013 at 12:36 PM, Waseem Saifi waseemsa...@gmail.comwrote:
Dear Experts,
Is it possible to make a pivot table basis
what we can do?...both workbooks VBA coding is password protected
.
Enjoy
Team XLS
On Fri, Aug 23, 2013 at 7:33 PM, Sanjay Mandal
sanjaykumarmanda...@gmail.com wrote:
Dear all
MIS Details 2013 to 2014 IN* CALL USERFORM* DAILY TRANSFER SHEET-13
*Regards.
Hi Ali,
We can use Sumifs or Sumproduct
=SUMPRODUCT(($B$1:$B$27=41317)*($B$1:$B$27=41325),$A$1:$A$27)
=SUMIFS($A$1:$A$27,$B$1:$B$27,=41317,$B$1:$B$27,=41325)
.
Enjoy
Team XLS
On Thu, Aug 22, 2013 at 8:33 PM, Ali Abbas tigarman...@gmail.com wrote:
Dear all. How can
Try This
Sub Chart_Titles()
Dim ch As ChartObject
For Each ch In ActiveSheet.ChartObjects
ch.Activate
ch.Chart.ChartTitle.Select
Selection.Format.TextFrame2.TextRange.Font.Name = Arial
Selection.Format.TextFrame2.TextRange.Font.Size = 14
Next
End Sub
Hi,
Please elaborate some more
OUTPUT REQUIRED with any specific value or just group concatenate, if
any specific value please mention
please explain role of CODES or Text column
.
Enjoy
Team XLS
On Sun, Aug 18, 2013 at 9:32 PM, Rashid Khan prkha...@gmail.com
try below code
just change Path or filename name extn. (.xls to .xlsx or other )
Sub clubefile()
Dim num As Integer
Dim x As Integer
Path = C:\Documents and Settings\xlstime\Desktop\delete\
Filename = Dir(Path *.xls)
Do While Filename
Workbooks.Open Filename:=Path Filename
Hi,
Try below code for consolidate worksheet.. then use pivot table for 2nd
requirement or send the example sheet
Sub Combine()
Dim NumSheets As Integer
NumSheets = Worksheets.Count
Worksheets(1).Select
Sheets.Add
ActiveSheet.Name = Consolidated
For X = 1 To NumSheets
Worksheets(X + 1).Select
try below link
http://www.excel-pratique.com/en/vba.php
.
Enjoy
Team XLS
On Thu, Aug 15, 2013 at 1:13 PM, jmothilal gjmothi...@gmail.com wrote:
Dear All
Request to send basic macro commands like for loop, assigning value ,
detecting row and column value .. etc
Welcome Niraj
.
Enjoy
Team XLS
On Sun, Aug 4, 2013 at 10:56 AM, Niraj Shirali nirajshir...@gmail.comwrote:
Hello All,
My name is Niraj Shirali, from Mumbai. Working with BNY Mellon. Looking
forward to learn VBA_macros in depth. Have developed some automations in
Hi Niraj,
You can learn VBA online... try below link
http://www.excel-pratique.com/en/vba.php
.
Enjoy
Team XLS
On Sun, Aug 4, 2013 at 10:46 AM, Niraj Shirali nirajshir...@gmail.comwrote:
Hi,
I'm new to this group and I'm hoping someone to help me guide. I'm from
If i am correct
Please find below formula
=VLOOKUP(C8,$I$7:$J$9,2,0)*(1+$G$3%)
.
Enjoy
Team XLS
On Thu, Aug 1, 2013 at 7:51 PM, SAJID MEMON sajidwi...@hotmail.com wrote:
Dear Experts,
My project in last stage, just your little co-operation I will complete my
wrote:
create defined name in example : *Eval**A2* that referring to
=EVALUATE(A2)
Then in some cell in that sheet, just type *=EvalA2**
*
Pada 28/07/2013 14:59, xlstime menulis:
and what about formula
.
Enjoy
Team XLS
On Sun, Jul 28, 2013 at 11:10 AM, De
On Tue, Jul 30, 2013 at 12:31 PM, xlstime xlst...@gmail.com wrote:
if we have more then thousands of records than?
.
Enjoy
Team XLS
On Mon, Jul 29, 2013 at 9:41 PM, Secret Shot secrets...@gmail.comwrote:
Put = sign in cell A2 itself at the bagining of the text
please check you group setting
--
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
Function**
* :-X
On 28/07/2013 12:09, xlstime wrote:
Hi All,
How to Evaluate cell value.
let assume that, in cell A2 - '1+2+3+4'
now how to sum or calculate cell value
hint: evaluate
.
Enjoy
Team XLS
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel
Hi All,
How to Evaluate cell value.
let assume that, in cell A2 - '1+2+3+4'
now how to sum or calculate cell value
hint: evaluate
.
Enjoy
Team XLS
--
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
Santoh,
9E+307 is the largest numeric value that can be represented in Excel.
.
Enjoy
Team XLS
On Thu, Jul 25, 2013 at 1:09 AM, santosh subudhi
santoshkumar.subu...@gmail.com wrote:
Hi Group,
Need information on what is 9E+307 and when/where/how to use it.
Few
Hi Ashish,
Try this
Function Reverse(Text As String) As String
Dim i As Integer
Dim StrNew As String
Dim strOld As String
strOld = Trim(Text)
For i = 1 To Len(strOld)
StrNew = Mid(strOld, i, 1) StrNew
Next i
Reverse = StrNew
End Function
.
Enjoy
Team XLS
On Sun, Jul 21, 2013 at 12:54 AM, MLT mlthorn...@gmail.com wrote:
I'm trying to figure out the syntax to use a function within the Indirect
function. I would like to do something like this but am getting a #REF
error:
=INDIRECT(SUM(A1:A3))
I missing in our formula (iserror)
=IF(ISERROR(MATCH(C1,$E$1:$E$99,0)),,C1)
.
Enjoy
Team XLS
On Tue, Jul 9, 2013 at 5:22 PM, raghunandan rallapalli
raghunandan.rallapa...@gmail.com wrote:
Sir, kindly give solution for the attached file,
thanks in advance
--
Please elaborate some more
.
Enjoy
Team XLS
On Thu, Jul 4, 2013 at 4:49 PM, Manoj Kumar manoj.11...@gmail.com wrote:
On Thu, Jul 4, 2013 at 4:47 PM, Manoj Kumar manoj.11...@gmail.com wrote:
Dear Expert,
Please help to sove my Quiry file attached in mail.
Hi,
Try belo link
http://www.wiziq.com/online-tests/19180-advance-excel
http://www.gobookee.net/advanced-excel-test-questions-answers/
http://www.accessanalytic.com.au/Free-Excel-Test.html
.
Enjoy
Team XLS
On Mon, Jul 1, 2013 at 9:57 AM, Prabhakar S H
Welcome Sandeep
Looking forward to your active participation in group.
Keep posting
.
Enjoy
Team XLS
On Thu, Jun 27, 2013 at 10:57 AM, sandeep shivpujan singh
mandy07s...@gmail.com wrote:
Hi Everyone,
I am Sandeep S Singh from India Hyderabad. I am a Software
why need macro ?try pivot table
please find attached file
.
Enjoy
Team XLS
On Thu, Jun 27, 2013 at 6:30 PM, vikas khen vikk...@gmail.com wrote:
Dear All,
Please find the excel sheet. I need macro for the same
Regards
--
Are you =EXP(E:RT) or
Hi Prabhakar,
*Please find attached solution...hope its fulfill your requirement *
.
Enjoy
Team XLS
On Tue, Jun 18, 2013 at 3:12 PM, Prabhakar S H prabakar.k...@gmail.comwrote:
Hi Team,
I want to split data into name, bank account no ifsc code separetely in
Hi Deepak,
Please elaborate your requirement little more.
.
Enjoy
Team XLS
On Sun, Jun 16, 2013 at 10:03 AM, Dheeraj Bankoti dbank...@gmail.comwrote:
Dear Ahmed,
Thanks for your reply. avergeifs does not meet as per my requirement. It
is working for complete
try below link
http://www.excel-pratique.com/en/vba.php
.
Enjoy
Team XLS
On Tue, Jun 11, 2013 at 4:26 PM, Gaurav Garg gaurav7...@gmail.com wrote:
Hello Friends,
** **
Does anyone have training material on VBA? Could you please share.
** **
In case if
try below VBA code
Sub conditionalreplace()
Dim rng As Range
For Each rng In Range(D1:D10)
If rng.Value 0.8 Then
rng = .80
End If
Next
End Sub
.
Enjoy
Team XLS
On Thu, Jun 6, 2013 at 11:18 AM, Amit Desai (MERU)
you can define range name using Name Define manager
.
Enjoy
Team XLS
On Fri, May 31, 2013 at 10:31 AM, Amit Desai (MERU) amit.de...@merucabs.com
wrote:
I have multiple Pivots in which I need to change the data table range
all together..
** **
Is there any
Hi Amar,
Just press Alt+E+K then change source or break link if no need
[image: Inline image 2]
.
Enjoy
Team XLS
On Fri, May 31, 2013 at 3:21 PM, amar takale amartak...@gmail.com wrote:
Dear All
Can anybody tell me why Error show while excel file opening.when I
use sumifs with index and match combination..please find attached solution
.
Enjoy
Team XLS
On Thu, May 30, 2013 at 1:03 PM, Chaya chayamon...@gmail.com wrote:
Dear Experts,
I was trying to find the values from Rows and coumns which match the
criteria from
Hi Deepak,
Please find attached solution
.
Enjoy
Team XLS
On Thu, May 30, 2013 at 1:34 PM, Deepak Rawat deepakexce...@gmail.comwrote:
Hi,
I have to count unique count of date citywise
Kindly help on both ( formula macro)
file is attached
Thanx Regards,
firstly install flash player then try to play
and for more information about Embed swf in word file
http://www.walkernews.net/2009/04/24/how-to-embed-swf-file-or-shockwave-flash-object-in-microsoft-word-2007/
.
Enjoy
Team XLS
On Thu, May 30, 2013 at 5:12 PM,
1 - 100 of 254 matches
Mail list logo