Anil
Sort the data after use formula.
Regards,
Brajesh
On Thu, Sep 29, 2011 at 10:54 AM, anil kumar wrote:
> Hello sir,
>
>
> frist of all thanks for reply. I used your formula but it is not work
> according to my data. I have attched that file. plz see that.
>
>
>
> Thanks & Regards
>
>
> A
Hello sir,
frist of all thanks for reply. I used your formula but it is not work
according to my data. I have attched that file. plz see that.
Thanks & Regards
Anil
--
--
Some important links for excel users:
I have a spreadsheet where I track my Poker play. I play a few times
per week. The amount of play varies a lot. Each time I play I add a
row to a sheet with the date, hrs played, loss, win, etc and computer
various values; cash flow, win / loss ratio, best day of week to play,
best game, etc. e.
Paul and Ashish,
You guys have been terrific - thank you for ALL your help!!!
Sincerely,
Kent
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Paul Schreiner
Sent: September 28, 2011 2:46 PM
To: excel-macros@googlegroups.co
Thanks for the response, but unfortunately this doesn't work with the
XIRR function as it only accepts 1-dimensional ranges. The resulting
‘urmg’ variable is a 2-dimensional range since the first range is in
column B and the second range is in column C.
The reulting urmg range basically looks lik
your example should save the file as:
"\\server8\cpd\CompReserve\kents folder\TEST FOLDER.xls"
if you're wanting to save it with the current name in the folder called:
"\\server8\cpd\CompReserve\kents folder\TEST FOLDER"
then you should use:
"\\server8\cpd\CompReserve\kents folder\TEST FOLDER\"
Hi Ashish,
Thank you for getting back to me so quickly. I managed to get
the columns and rows unhidden thanks to your advice, however, I am unable to
change the saving location - it keeps saving to the original folder and not to
the destination folder ("\\server8\cpd\CompReserve\
Hi Anil
If you are not doing calculation with numbers then you can change the format
to text
check whether this helps
http://office.microsoft.com/en-us/excel-help/display-numbers-as-credit-card-numbers-HA010236840.aspx
HTH
Mahesh
On Wed, Sep 28, 2011 at 9:39 PM, XLS S wrote:
> Hey Anil,
>
>
add
For Each wk In wkb.Sheets
wk.select
Cells.EntireRow.Hidden = False
Cells.EntireColumn.Hidden = False
and
replace wkb.Path & "/"
in wkb.SaveAs wkb.Path & "/" & Left(wkb.Name, InStrRev(wkb.Name, "")) &
".xls"
with ur path "c:\" etc
On Wed, Sep 28, 2011 at 9:11 PM, HarryP Knuckles w
Sub union_data()
Dim s As Range, unrng As Range
Set unrng = Union(Range("b1:b4"), Range("c4"))
For Each s In unrng
MsgBox s.Value
Next
End Sub
On Wed, Sep 28, 2011 at 9:04 PM, excelCPA wrote:
> I am trying (unsuccessfully) to dynamically transform a single column
> non-contiguous data range to
Hey Anil,
Microsoft Excel stores numbers with up to 15 digits of precision. If a
number contains more than 15 significant digits, Microsoft Excel converts
the extra digits to zeros (0).
You have 2 options:-
You already know one of them
Put an apostrophe (') in front of the number.
That's OK for
I am trying (unsuccessfully) to dynamically transform a single column
non-contiguous data range to single column contiguous range using VBA,
basically dynamically appending the second range to the first.
My spreadsheet is as follows:
Column A contains a series of dates in sequential order
Column
Good morning guys,
You guys have been super helpful! I have
a macro that is working well but would like to do two things with it.
1) I would like to have all the columns and rows automatically
unhidden for each worksheet.
2) I would like the save location changed to: ‘
Good morning guys,
You guys have been super helpful! I have
a macro that is working well but would like to do two things with it.
1) I would like to have all the columns and rows automatically
unhidden for each worksheet.
2) I would like the save location changed to: ‘
Hi Sam,
Thanks for your reply.
Once the cells in Column A match towards Column B should not consider for
second time.
For eg: 3 & 5 is already matched with 8 in column B. so these cells should
not come for next calculation.
/Suresh
On Wed, Sep 28, 2011 at 9:04 PM, Sam Mathai Chacko wrote:
>
what about 6 and 3 as a match for 9
On Wed, Sep 28, 2011 at 9:01 PM, suresh k wrote:
> Hi All,
>
> Any macro man can help me on this.
>
> I have attached the excel with my query.
>
> /Suresh
>
> --
>
> --
> Some impo
Hi All,
Any macro man can help me on this.
I have attached the excel with my query.
/Suresh
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceld
This macro will do it
option explicit
Sub TransposeEmSAS()
Dim r As Long
Application.ScreenUpdating = False
Columns("J").Resize(, 2).Insert
r = 2
doit:
If Cells(r + 1, 1) = "" Then GoTo deletecolumns
Rows(r + 2).Resize(4).Insert
'copy colors
Range("L2:P2").Copy
Cells(r + 1, "j").PasteSpecial Paste
Kindly Share the sheet
On Sep 28, 1:09 pm, Anil Bhange
wrote:
> Hi Experts,
>
> I wanted your help in below points,
>
> 1. In excel my companies Bank account number is more than 20 digit
>
> 2. And there are approx. 100 bank account numbers
>
> 3. When I copy those numbers from one excel
Take the help of Pivot
On Sep 28, 10:40 am, shashank bhosle
wrote:
> Hello Friends,
>
> I have attach the sheet which included two table
> T1
> T2
>
> i want to change the T1 data to T2
>
> Please help
>
> Regards
> Shashank
> 9422927499
>
> Phase I.xls
> 44KViewDownload
--
---
If you have excel 2007 then follow the following procedure
Select the your data range and go to Home --> Conditional Formatting
-->Highlight Rules--> Duplicate Values..
It will highlight your duplicate data and by filtering it you can copy it.
Regards
Hemal
9260544391
--
Better to add single quote ( ' ) before bank account number .
and while you copy that number to another cell, it will remain same.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
Hi Experts,
I wanted your help in below points,
1.In excel my companies Bank account number is more than 20 digit
2.And there are approx. 100 bank account numbers
3.When I copy those numbers from one excel to another digits after 15
alphabet convert to "0"
4.What I understood
Dear Anil,
See below formula if it help to You.
=IF(A2=A3,"Duplicate","Unique")
Regards,
Brajesh
On Wed, Sep 28, 2011 at 12:46 PM, anil kumar wrote:
> Hi everybody,
>
> I have a file in which some data is double i want to find that data. I used
> short key Alt + AM but it is remove double d
Hi everybody,
I have a file in which some data is double i want to find that data. I used
short key Alt + AM but it is remove double data insted of show data i want
to copy that data.
Thanks & Regards
Anil
--
25 matches
Mail list logo
