On Saturday, January 6, 2018 at 7:55:55 AM UTC-8, Deepu Raj wrote:
>
> how to remove 1025 to 25 or 140 to 40 ie hundred and thousand removing
> using excel
>
It has already been suggested to use the RIGHT function, but also use the
VALUE function. Assuming the number is in A1 the
formula =V
Hi,
Try
Dim IFileName As Variant
Dim SFileName As Variant
Public Sub IButton_Click()
IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
MsgBox IFileName
End Sub
Public Sub IIButton_Click()
SFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
Msg
Hi David,
let me know the fields and how would you want it to be created.
Umesh
On Mon, Jan 24, 2011 at 12:32 AM, DavidG wrote:
> how do i add a file?
>
> On Jan 21, 8:57 pm, DavidG wrote:
> > Hi
> >
> > I am trying to build a system for a hairdressers to manage their
> > contacts and activit
how do i add a file?
On Jan 21, 8:57 pm, DavidG wrote:
> Hi
>
> I am trying to build a system for a hairdressers to manage their
> contacts and activity. I have tried using access which is the obvious
> answer but I am struggling with the relationships. So i thought excel
> might do the job. I ne
col_index_num is mandatory for vlookup function, range_lookup is
optional.
If range_lookup is not given it will take it as TRUE.
One important point for using Vlookup is that the table array should
be sorted on the first column.
On Jul 21, 8:31 pm, preeti vora wrote:
> Hi team,
>
> when we do v
Hi Preeti
Pls let us know what you want to do, or if possible please attach a
sample sheet.
Regards
Rajender Soni ! 750 322 55 50
On Jul 21, 8:31 pm, preeti vora wrote:
> Hi team,
>
> when we do vlookup is that possible without col_index_num and range_lookup
> for use vlookup..or can we use any
Hi Karthik,
Try below options:-
1. Go to this link:- http://www.meadinkent.co.uk/excel-color-calcs.htm
Now using help given there, you can insert a new column and then you can
filter out the colored cells based on this column.
2. Go to this group web discussion page and try looking some older p
Hi Karthik,
Try below options:-
1. Go to this link:- http://www.meadinkent.co.uk/excel-color-calcs.htm
Now using help given there, you can insert a new column and then you can
filter out the colored cells based on this column.
2. Go to this group web discussion page and try looking some older
Hi Paul,
Appreciated your reply,
I have downloaded a cvs file (from an online tool in my office and
also from MS Access) and I try to view in Excel.
It saturates number of row..
On 4/24/09, Paul Schreiner wrote:
> You're WAY to frugal with your info...
>
> "I have a data" ...
> What FO
U can download the Compatibility pack and u can retrieve the data
http://office.microsoft.com/en-us/products/HA101686761033.aspx
Regards
Sathish Jalendran
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of raafi barey
Sent: 24 A
You're WAY to frugal with your info...
"I have a data" ...
What FORMAT is the data in?
Where are you getting it from?
"is more than the capacity of excel 2002".
Is it because if there is too many rows? or too many columns?
I mean, the answer if your file is:
a) a text file
b) th
Hi Ashish,
Thanks Alot. This is great. I am able to open the desired link. However
now I need to copy the value of each cell in a column to the search field of
this site and then click. I know that I can run a loop to copy value from
each cell and then paste it in the search field.
I then need
Hi Ashkaran,
Please mention the site where you want to do this. Please try this
possible solution too.
Possible Solution -
http://www.excelitems.com/2009/03/access-search-engines-on-browser.html
For more tips, tricks, downloads and problem solutions: visit -->
http://www.excelitems.com
I'm not sure if his would help you?
Download Personnel Timesheet 08-12-07.xls at http://normay.741.com/
Norman May
On Sat, Jan 10, 2009 at 1:44 PM, How Do you? wrote:
>
> I'm using excel to do weekly time sheet and I created another page/tab
> with in the same workbook and I'm trying to post job
It's easy just send me the sheet...Need to use "branching" and "lookup
functions"
i.e. If statement and lookup function to get this done
Regards,
Tariq Kamal
www.gate2quality.com
www.rideahead.blogspot.com
On Sun, Jan 11, 2009 at 12:14 AM, How Do you? wrote:
>
> I'm using excel to do week
15 matches
Mail list logo
