*Offset ([row], [column])*
lets say i => Range B3 => same as i.offset(0,0)
thenif we want to select Range C4 that should be i.offset(1,1) => 1 Row
and 1 column from B3
If we want to select A1 ==> i.offset(-2,-1) => 2 Row before and 1 column
before B3
*i.Offset(, 2) = i & "|" & i.Offset(, 1
Its the biggest number excel knows. Assuming you have a list of numbers in
column A and you always want excel to deliver the last number in the row to you
anytime you update the row. You can use lookup(9e+307,a:a). Your way of telling
excel look for the last number in column A or any range where
=SUMIF($A$4:$A$54,H4,$B$4:$B$54)
use this formula
From: suresh k
To: Excel group
Sent: Wednesday, July 24, 2013 6:20 PM
Subject: $$Excel-Macros$$ Sum query
Hi All,
I have attached my query regarding sum function query
I know this can be solved through
You can use Sumif
It's so simple !
it is simplest query I have ever found on this group.
Regards,
Waseem Saifi
On Wed, Jul 24, 2013 at 6:51 PM, Ravinder Kumar <
ravinderbhardwa...@gmail.com> wrote:
> Hi
>
> With the help of SUM IF, you can get the result.
>
> For ref. PFA
>
>
> On Wed, Jul 24,
- Forwarded Message -
From: Waseem Saifi
To: excel-macros
Sent: Wednesday, July 24, 2013 11:50 AM
Subject: Re: $$Excel-Macros$$ Want conditional lookup
Dear Laxman,
PFA.
On Wed, Jul 24, 2013 at 11:13 AM, LAKSHMAN PRASAD
wrote:
Dear Expert,
>Want conditional lookup fro
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.
>
Hi Group,
Need information on what is 9E+307 and when/where/how to use it.
Few example will be of very helpful to me with supporting links.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
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
Hi, see (attached) if that's what you want
Em quarta-feira, 24 de julho de 2013 07h29min47s UTC-3, Pravin Gunjal
escreveu:
>
> Hello,
>
>
>
> I would like to translate this attached PDF texts (words) in to English to
> work out on it. I tried my best but couldn't get the exact result. Can
Hi DP
Perfect code
Thanks For Your Time and Efforts.
On Wed, Jul 24, 2013 at 7:53 AM, De Premor wrote:
> I think you only need a foldername :D
> Try to change ListIt Function with this rev
>
> Private Function ListIt(SelectedPath As String, Optional tCol As Integer =
> 0)
> Dim FSO As S
Sub file_names_including_sub_folder()
Application.ScreenUpdating = False
Dim fldpath
Dim fld As Object, fil As Object, fso As Object, j As Long
With Application.FileDialog(msoFileDialogFolderPicker)
.Title = "Choose the folder"
.Show
End With
On Error Resume Next
fldpath =
Application.FileDialog(ms
I think you only need a foldername :D
Try to change ListIt Function with this rev
Private Function ListIt(SelectedPath As String, Optional tCol As Integer
= 0)
Dim FSO As Scripting.FileSystemObject, sFolder, sSubFolder, lPath,
sFile
On Error Resume Next
Set FSO = New Scripting.Fil
Thanks Dp,
But its giving only Nested foldersname.
I want files name.
Anyway i got idea from your Code
On Wed, Jul 24, 2013 at 7:22 AM, De Premor wrote:
> PFA
>
> Dim Rng As Range, iRow As Integer
>
> Sub GetFolder()
> Dim fldr As FileDialog
> Set Rng = ActiveCell
> Set fldr = Appl
Hi
With the help of SUM IF, you can get the result.
For ref. PFA
On Wed, Jul 24, 2013 at 6:20 PM, suresh k wrote:
> Hi All,
>
> I have attached my query regarding sum function query
> I know this can be solved through pivot table, but I want the result in
> formulaes.
> Pls let me know if any
PFA
Dim Rng As Range, iRow As Integer
Sub GetFolder()
Dim fldr As FileDialog
Set Rng = ActiveCell
Set fldr = Application.FileDialog(msoFileDialogFolderPicker)
fldr.AllowMultiSelect = False
If fldr.Show = -1 Then Call ListIt(fldr.SelectedItems(1))
End Sub
Private Function Lis
Hi All,
I have attached my query regarding sum function query
I know this can be solved through pivot table, but I want the result in
formulaes.
Pls let me know if anyone can solve this?
/Suresh
--
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) !
Thank for quick response But this code is not working fine .
Its giving Only first folder 's file name .
I mean I have lots of folder and and file in main folder.and folder
contain further folders and file and these folder also contains some
folder and files.
So i want all files name from all
Hi Priti,
Please see if it help
Public Sub selectfol()
On Error Resume Next
Set path1 = CreateObject("Shell.application").browseforfolder(0, "Please
choose a folder", 0, openat)
pathm = path1.self.Path
UserForm1.TextBox1.Text = pathm & "\"
mysourcepath = pathm & "\"
Set myobject =
Sorry for previous incomplete mail,
Help me on this ,
i want all files name from folders.
Folder1 File1,file,2,
folderA file3,file4,file5
folderB file6,file7
folderCfile8
folder2file 9
folderD file10
folderE
Hi everyone,
Help me on this ,
i want all files name from folders.
Folder1
foldera
folderb
--
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
Hi,
Instead of Macro, you can use ASAP utlities to split various sheets in one
excel file.
Rgds,
Prabhakar
On Monday, July 22, 2013 4:52:05 PM UTC+5:30, ca_k...@yahoo.co.in wrote:
> Dear Excel experts,
>
> I want one macro which can spit varios sheets of one excel file to related
> other
Dear Laxman,
PFA.
On Wed, Jul 24, 2013 at 11:13 AM, LAKSHMAN PRASAD
wrote:
Dear Expert,
>Want conditional lookup from sheet 1 those data which is active in column A ,
>plz the attached file
>
>Thanks,
>Regards
>LAKSHMAN--
>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wan
Dear Laxman,
please share file
I have deleted previous mail and also that file from my computer
On 7/24/13, LAKSHMAN PRASAD wrote:
> Dear waseem,
>
> Plz C the sheet2 where unit no.249 found but sheet1 not pickup that value
>
>
>
>
>
> From: Waseem Saifi
> To: e
You can try this code
Change Workbook name as per your Workbook name
wkbMoveto Is that workbook in which you want to past data
wkbMoveFrom is that workbook from which you want to copy data
Sub Copydata()
Dim wkbMoveto As Workbook
Dim wkbmoveFrom As Workbook
Dim wksMoveto As Workshe
Dear waseem,
Plz C the sheet2 where unit no.249 found but sheet1 not pickup that value
From: Waseem Saifi
To: excel-macros
Sent: Wednesday, July 24, 2013 11:50 AM
Subject: Re: $$Excel-Macros$$ Want conditional lookup
Dear Laxman,
PFA.
On Wed, Jul
Respected Devanand,
I think you have exported the same from tally.In tally you have the option
to sort the details before exporting.You can do the same in excel
also.First sort the data according to the TIN NO.The select the data and
apply subtotal.In subtotal column select TIN NO and select the c
25 matches
Mail list logo
