Welcome All :)
.
Enjoy
Team XLS
On Thu, Aug 6, 2015 at 11:36 PM, hari kumar prekkeh...@gmail.com wrote:
Access import from excel
Once u created one data table n data, if the same details are in other 4
worksheets also. Use import from excel say append to existing
You can also use Split function with array in VBA
.
Enjoy
Team XLS
On Thu, Jan 22, 2015 at 1:41 PM, Ashish Kumar kumar.ashish...@gmail.com
wrote:
PFA
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
let Start date in b2 and end date in b3 then in cell c2
=IF(($B$2+ROW(B1)-1)$B$3,,($B$2+ROW(B1)-1))
for very basic formula you can also use array or UDF if you want.
.
Enjoy
Team XLS
On Fri, Dec 12, 2014 at 5:48 PM, Mandeep Baluja rockerna...@gmail.com
wrote:
Just
Sorry, in excel there is no shortcut related specify format...
you can use ctrl+shift+@ for general time format
.
Enjoy
Team XLS
On Wed, Nov 26, 2014 at 3:29 PM, Mandeep Baluja rockerna...@gmail.com
wrote:
[h]:mm:ss
What is the keyboard shortcut to set the time in
is this your question for help...do you want to check our knowledge?
.
Enjoy
Team XLS
On Wed, Nov 26, 2014 at 4:02 PM, Mandeep Baluja rockerna...@gmail.com
wrote:
build this hope this help someone else.
Sub Format_to_time()
Selection.NumberFormat = [h]:mm:ss
is concerned you are far better than me.
On Wednesday, November 26, 2014 4:07:51 PM UTC+5:30, XLS S wrote:
is this your question for help...do you want to check our knowledge?
.
Enjoy
Team XLS
On Wed, Nov 26, 2014 at 4:02 PM, Mandeep Baluja rocke...@gmail.com
wrote
Dear
Change your database name if you want to use another database
.
Enjoy
Team XLS
On Sun, Sep 28, 2014 at 12:25 AM, renuka chari jva.ch...@gmail.com wrote:
Dear sir,
thanks for your valuable efforts
while run the code i received the error message has been
Some general questions like
1) How many type of Join's and what is the difference between right,left
and full join
2) what is cross tab
3) how to make pivot report or normal report
like that
.
Enjoy
Team XLS
On Wed, Sep 17, 2014 at 2:04 AM, Rudra Thapa
try enclosed
.
Enjoy
Team XLS
On Sat, Sep 13, 2014 at 4:13 PM, Ashish Bhalara ashishbhalar...@gmail.com
wrote:
Dear experts,
I have column with heading of SR and fillup with 1 to 10.
I need a macro to insert blank row under 10 with continue series
11,12,13...
Hi Anil,
Try yourself with below online tutorial. if you need help, you can revert.
http://www.excel-pratique.com/en/vba.php
.
Enjoy
Team XLS
On Tue, Jul 29, 2014 at 1:46 PM, anil nim anilnim1...@gmail.com wrote:
Dear all,
I want to learn Macros and VBA from any
try this .. only formula used nothing else
.
Enjoy
Team XLS
On Fri, Jul 18, 2014 at 10:30 AM, my excel myxlg...@gmail.com wrote:
Sir,
i sent attached file of my friend ration shop
pls see out put data
he wanted a macro to generate output data
pls help
try below
[=1000]$ ##\,##\,##\,##0;[=10] ##\,##\,##0;##,##0
.
Enjoy
Team XLS
On Fri, Jul 18, 2014 at 2:32 PM, Rohan Young rohan.j...@gmail.com wrote:
*Hi Experts*
* how do get US$ currency format from 1234567 to 1,234,567*
thanks
--
Are you =EXP(E:RT)
Dear Delin,
Please try below link.
http://www.excel-pratique.com/en/vba.php
Its a very useful and simple
.
Enjoy
Team XLS
On Mon, Jul 14, 2014 at 10:56 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA
MACROS excel-macros@googlegroups.com wrote:
Dear All,
Good day to you
Hi,
Search in google about MODI OR OCR in VBA
Or check below link
www.ozgrid.com/forum/showthread.php?t=147473
Sent from my iPhone
On Dec 6, 2012, at 11:43 PM, Indrajit $nai talk2indra...@gmail.com wrote:
Hi All,
Is it possible to convert a Bitmap image (BMP) into a Excel file through
Use Text formula for month like =text(d2,) and u can use text with
iferror formula
Sent from my iPhone
On Dec 2, 2012, at 12:43 AM, Hemantpokharkar hemant...@gmail.com wrote:
Dear All
Kindly help me to solve the problem
I have a excel sheet were i have required a formula which will
please send the example...
On Fri, Oct 21, 2011 at 1:56 PM, karan 1237 karan1...@gmail.com wrote:
Dear All,
Need your help to extract some specific text.
Exam.
Govt I Grade College, Pashachapur Tq Hukkeri Dist Belgaum (2007) A/S/C/
BBA. Enrol 139, Teacher 1, Principal-Dr S F Tangade.
I
if this is a fix. then use countif see the attachment
On Fri, Oct 21, 2011 at 8:51 PM, XLS S xlst...@gmail.com wrote:
please send the example...
On Fri, Oct 21, 2011 at 1:56 PM, karan 1237 karan1...@gmail.com wrote:
Dear All,
Need your help to extract some specific text.
Exam.
Govt I
Hey Karan,
that's great yaar !!!
]
On Wed, Oct 19, 2011 at 9:48 AM, karan 1237 karan1...@gmail.com wrote:
Hey Anil,
Convert your image files in excel through online or download a software
from the website below :
http://www.onlineocr.net/
http://www.cometdocs.com/
for only date use int()
and time use mod fuction
On Tue, Oct 18, 2011 at 3:02 PM, Muhammad Arslan arslanacca...@gmail.comwrote:
Dear Experts
I need to disjoint date and time form a text. Help me out how to tackle in
excel using formual. Text is following
4/11/2011 08:39:20 PM
Help me
Kindly send text file..
On Sat, Oct 15, 2011 at 5:55 PM, santhu santhosh.qat...@gmail.com wrote:
Hi,
How to extract a text file data to an excel sheet.
Ex: Sl.no FirstName MiddleName LastName Place
1 ABC abc India
2 DEF
firstly learn recording then play with recorded code
http://www.youtube.com/watch?v=Ycab4OiPug0
http://www.internet4classrooms.com/excel_record_macro.htm
http://office.microsoft.com/en-us/excel-help/record-and-use-excel-macros-HA001054837.aspx
for all your great support to group. Keep it up*
*Thanks to Don Guillett, Bheema, Venkat, GoldenLance, Ashish Koul, XLS S ,
Paul and other folks for helping excel enthusiasts voluntarily !! Keep it up
!!
*Keep posting.
Regards
Ayush Jain
Group Manager
Congratulation Ayush.
On Sun, Oct 2, 2011 at 8:40 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Group,
Our Group Manager Mr. Ayush Jain has been awarded the Microsoft MVP award
for the 2nd year in row...
Congrate Ayush
--
Thanks regards,
Noorain Ansari
Select cell or column then right click format cell ...then in
number tab go to date and select date format then ok
On Fri, Sep 30, 2011 at 11:03 AM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear
I like to put the date format in Excel as dd/mm/, and
Hey Rajan Babu,
which page?
On Sat, Oct 1, 2011 at 11:52 AM, rajan verma rajanverma1...@gmail.comwrote:
HI,
Please visit this Page to know more about Worksheet Events..
Regards
Rajan
On Sat, Oct 1, 2011 at 10:53 AM, Mr excel excelkeec...@gmail.com wrote:
HI group,
This is a Great
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
formula
XLS S xlst...@gmail.com Sep 23 05:01AM +0530
^#132961b47c59cc74_132939250e1a5959_digest_top
please specify requirement and condition
--
.
Topic: Convert txt file to
xlshttp://groups.google.com/group/excel-macros/t/ed925791abadc651
Use export and import function or right click on ur txt file and open with
excel
On Thu, Sep 22, 2011 at 4:20 PM, Sandeep Pathak
sandeeppathak...@gmail.comwrote:
Dear Team,
Is there any way to convert text file to excel, except change of
extension name...
Please advise...
Regards,
please specify requirement and condition
On Thu, Sep 22, 2011 at 9:20 PM, naanu v naanu2...@gmail.com wrote:
kindly provide macro for Index formula
--
--
Some important links for excel users:
1. Follow us on
use =int() function
The *Int* function returns the integer portion of a number.
On Fri, Sep 16, 2011 at 1:39 AM, Mich Mac michelle.maccrac...@nmss.orgwrote:
I am exporting a file from online which automatically includes dates.
This interferes with my Pivot tables. How do I convert an entire
try this
Sub copy_files()
Dim ServerA As String
Dim ServerB As String
ServerA = C:\temp\filename.dat
ServerB = C:\temp\filename2.xls
FileCopy ServerA, ServerB
End Sub
On Tue, Sep 13, 2011 at 7:30 AM, Prabhu prabhugate...@gmail.com wrote:
Hi All,
How to convert DAT to Excel file.
Now i
Use sumif or put pivot tableplease find the attachment..
On Tue, Sep 13, 2011 at 7:15 AM, Prabhu prabhugate...@gmail.com wrote:
Hi All,
I need to compare two columns and sum the unique value.
Example:
Apple 10
Orange 5
Apple 20
Mango 25
Orange 15
Mango 7
Result
Great!!! But Result not.
On Fri, Sep 9, 2011 at 10:39 AM, Venkat CV venkat1@gmail.com wrote:
Hi Varun,
See if Helps Attached...
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71
*
On Thu, Sep 8,
Venkat Ji...
Google Baba Ki Jai
http://msdn.microsoft.com/en-us/library/ezk76t25%28v=vs.71%29.aspx
On Fri, Sep 9, 2011 at 10:47 AM, Venkat CV venkat1@gmail.com wrote:
Dear All,
Find attached some Examples With Loops...in VBA it will useful
*Best Regards,*
*Venkat *
Hey Varun ,
thy this
=DATEDIF(A1,TODAY(),Y) Years, DATEDIF(A1,TODAY(),YM) Months,
DATEDIF(A1,TODAY(),MD) Days
On Thu, Sep 8, 2011 at 1:57 PM, VARUN CHAWLA varunchawla...@gmail.comwrote:
Can any body guide me the formula to calculate the Age in excel with months
and days.
Hey ,
Please send the attachment...
try the below link
http://www.contextures.com/xlcondformat02.html
http://www.wikihow.com/Apply-Conditional-Formatting-in-Excel
On Wed, Sep 7, 2011 at 1:30 PM, zp18 irvinep...@gmail.com wrote:
A1=the name of an employee, defined name is Suspect
A2= an
Hey Amit,
Try this
*Method 1:*
1. Open the Excel file
2. Then save the Excel file in html format
3. Then save the html document into xls but as another name
*For spreadsheets with only text:*
*Method 2:*
1. Open the Excel file
2. Save the Excel file as xml format
3. Save
9911868518
--
.
XLS S
Pagal Bana Dey
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group
and helped many people through his
expertise. He has been consistent contributor to this excel forum and has
acheived this recognition for second time consecutively.
Thanks to Noorain, Venkat, Sunny(XLS S), Don Guillett, and other folks for
helping excel enthusiasts voluntarily !! Keep it up
Userforms have 6 properties that relate directly to ScrollBars.
Set the .ScrollBars property to 2
Now, set the .ScrollTop to 0 (So it will appear always at the top of the
form)
and finally, you must change the .ScrollBarHeight to something... for
example, If the UserForm height is 100, try
Hey Satvik,
please find the below link
http://www.ozgrid.com/VBA/conversion-functions.htm
On Mon, Sep 5, 2011 at 9:28 AM, satvik...@gmail.com wrote:
** Hi guru,
Plz help me how to convert number in to a text.
Regards,
Satvik
Sent from BlackBerry® on Airtel
Hey Manager Sir,
Use proper syntax.
like
right([tablename.columnsname,num_char]
left([tablename.columnsname,num_char]
On Mon, Sep 5, 2011 at 4:03 AM, ScubaDude_ITmanager
blackjeepfinanc...@gmail.com wrote:
Okay, its and Access question but may be used in both. Right ([F2],
3) is used in
send the attachment in excel-macros@googlegroups.com email id
On Sat, Sep 3, 2011 at 9:41 AM, Bheema Shankar shankar.n...@gmail.comwrote:
how to attach my file.?
On Sep 1, 8:08 pm, ashish koul koul.ash...@gmail.com wrote:
Can you attach the sample file
On Thu, Sep 1, 2011 at 4:16 PM,
Hey Chandra,
try this
Function xxx(x, y)
Dim a, b, c As Range
a = Range(a4:a14) ' contains text
b = Range(b4:b14) ' contains text
c = Range(c4:c14) ' contains values
Range(a20) = Application.SumProduct((a = x) * (b = y) * c)
End Function
On Tue, Aug 30, 2011 at 11:56 AM,
Hey Kannan,
please find the below link
http://office.microsoft.com/en-us/excel-help/delete-duplicate-rows-from-a-list-in-excel-HA001034626.aspx
On Tue, Aug 30, 2011 at 5:57 PM, kannan excel kannan.ex...@gmail.comwrote:
Hi NOORAIN ANSARI,
Pls tell wat is this.??
if you feel free explain
Hey Anil,
this post sent by mr.Bob
If you want to import a text file into Excel and have that data be in
multiple columns once it's in Excel, it must be either fixed width or
delimited. Fixed-width means that new columns occur at the same place on
every line. That's not very useful for most
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of XLS S
Sent: Friday, August 19, 2011 7:16 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Very slow performance by Excel file
Try this...
Go to tools
then ..press Alt + D +P +B and select new range ...
On Mon, Aug 29, 2011 at 2:59 PM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
That’s true… but what if I wants to refresh the Pivot table with new
data?
** **
Best Regards,
Amit Desai
** **
** **
*From:*
:17 PM, XLS S xlst...@gmail.com wrote:
kindly put 3 condition it self and then send file.
try this code
Private Sub Worksheet_Change(ByVal Target As Range)
Set I = Intersect(Target, Range(B2:B8))
If Not I Is Nothing Then
Select Case Target
Case 0 To 100: NewColor = 37 ' light
well done rajan
On Sat, Aug 27, 2011 at 6:48 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Hi Group,
Refer the attached sheet with some Data Sorting Example. Hope you will like
it
** **
Rajan.
** **
--
Hey Jocky,
please find the attachment.
On Sun, Aug 28, 2011 at 7:08 PM, jocky Beta jocky6...@gmail.com wrote:
Hi,
Can you create same for me?
The Formula is given below.
*FORMULA - A = P* (1 + r/12)12
*P* is the principal (the initial amount you borrow or
for which location..
On Thu, Aug 25, 2011 at 10:16 PM, Rahul Gandhi myname.ra...@gmail.comwrote:
I Have 2 Off-roll Opening with me, One in Videocon as an Off-roll
Employee and One in Master Franchisee of United Colors of Benetton.
Package 2.5-3 Lac.
Please call @ 9711772297
Regards
hey Usha,
if blank cell come thru by formula then use if condition other wise use find
and replace function
On Fri, Aug 26, 2011 at 12:40 PM, Usha Gusain ushadhvin...@gmail.comwrote:
We have some blank cells in excel (2007), which we want to fill with zero.
what is the formula for the same?
Use pastespecial and transpose or try below link
http://www.vbaexpress.com/kb/getarticle.php?kb_id=144
On Fri, Aug 26, 2011 at 9:25 AM, GreenBriar impedimenta.st...@gmail.comwrote:
I have a series of spreadsheets that have data in them that needs to
be formatted into 3 columns instead of
alos try this link
http://www.vbaexpress.com/kb/getarticle.php?kb_id=144
On Fri, Aug 26, 2011 at 7:15 PM, GreenBriar impedimenta.st...@gmail.comwrote:
Transpose would not work because every 4th record (or row) would need to go
back to the first column, next row.
original data could be in
try formula please find attachment...
On Thu, Aug 25, 2011 at 8:04 PM, Robert Jacobs robertjacob...@gmail.comwrote:
Thanks in advance experts!!! This is very complicated to explain, but
I'll give it a go:
I have data (Invoice#, Invoice Year, Cat1 Sales, Cat2 Sales, Cat3
Sales), and
Hey Amit,
open this e-mail in internet explores and then copy past
On Fri, Aug 26, 2011 at 7:17 PM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Dear Friends,
** **
I have recd the following data in email body itself wants to convert them
in number to have sum of it. Let me know
kindly put 3 condition it self and then send file.
try this code
Private Sub Worksheet_Change(ByVal Target As Range)
Set I = Intersect(Target, Range(B2:B8))
If Not I Is Nothing Then
Select Case Target
Case 0 To 100: NewColor = 37 ' light blue
Case 101 To 200: NewColor = 46 '
Hey Nandkumar,
where is due date column.
and use conditional formation for highlighting
On Thu, Aug 25, 2011 at 10:07 AM, Nandkumar kakvipure
nandkumar.hindust...@gmail.com wrote:
-- Forwarded message --
From: shridhar pandit shriidhar.pan...@gmail.com
Date: Thu, Aug 18,
Hey Noorain,
it's perfectly working
On Thu, Aug 25, 2011 at 3:43 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Frederic,
This function LOOKUP(9^9,A:A) is not working..
We are unable to find Adject Output, it is showing #N/A error..
--
Thanks regards,
Noorain Ansari
Hey Atul,
Please find the below links,
http://www.ozgrid.com/VBA/Functions.htm
http://www.codeproject.com/KB/macros/excelmvf.aspx
http://www.vertex42.com/ExcelArticles/user-defined-functions.html
On Tue, Aug 23, 2011 at 11:42 PM, Atul vishwakarma atulkuma...@sify.comwrote:
Hi Rajan,
Due to
please send vba code...
On Wed, Aug 24, 2011 at 7:52 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hello,
I am getting **PASTE EXCEL CELLS HERE** error(Range Not found) when I
send mail by using vba code. Please let me know whats the error is.
Thanks,
Chandru
--
Desai
Assistant Manager, Fleet MIS (Corporate)
Desk No.: 022 40520129
Cell No.: 9867232534
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of XLS S
Sent: Friday, August 19, 2011 7:16 PM
To: excel-macros@googlegroups.com
Subject
Hey Anwar,
It would be very helpful if your data could result in an actual case with a
real example.
On Mon, Aug 22, 2011 at 2:26 PM, Anwar Mohd anr7no...@gmail.com wrote:
Hi Rajan,
I need the Summary tab in Quarter wise only.
Regards
Anwar
-- Forwarded message --
The sender of this email is registered with Naukri.com as Helios Matheson
It Ltd.
*Dear Candidate,*
HI,
Greetings from Helios Matheson IT Ltd.,
We are a leading healthcare focused IT services company. We are a public
limited company listed in NASDAQ, NASCOM, and BSE. We provide consulting and
because it's not a right condition not equal to 0.00..please try it
self ...just copy and paste spicel and check cell value..
On Mon, Aug 22, 2011 at 9:50 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
Hi All,
I want hello in filtering data.
In attached file if I am applying in
use this...
=INT(ROUND((BC3-BD3),1)) then put filter
On Mon, Aug 22, 2011 at 10:21 PM, rajan verma rajanverma1...@gmail.comwrote:
see if it helps
On Mon, Aug 22, 2011 at 10:00 PM, XLS S xlst...@gmail.com wrote:
because it's not a right condition not equal to 0.00..please try
Hey Amit,
Please find the attachment.
On Sat, Aug 20, 2011 at 10:53 AM, Amit Desai (MERU) amit.de...@merucabs.com
wrote:
Thanks this helped…
** **
Now what if I need, TAT range (0 – 2 day, 3 – 7 days, etc…) next to
“Completion time in Days” column in the attached file?
Try this...
Go to tools -- options -- select Calculation tab -- check on
manual and make sure you check on recalculate before save. this is
going reduce the time taken by excel to calculate the formulae present
in your sheet. hence increasing the performance. I'm sure that you
have lot of
pleas find the below link..
http://forum.codecall.net/visual-basic-programming/4676-how-implement-lifo-fifo-method.html
On Fri, Aug 19, 2011 at 4:06 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear Sirs,
anybody please help regarding FIFO method in Ms Access 2003. Please see
hey rajan,
what is the mean of 1440/60?
On Fri, Aug 19, 2011 at 7:22 PM, Rajan_Verma rajanverma1...@gmail.com wrote:
Try this
=((C2+D2)-(A2+B2))*1440/60
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of jayendra gaurav
Sent: Friday, August 19,
What-if analysis is the process of changing the values in cells to see how
those changes will affect the outcome of formulas on the worksheet.
Three kinds of what-if analysis tools come with Excel: scenarios, data
tables, and Goal Seek.
1) Scenarios and data tables take sets of input values and
Hey N Pradhan,
please find the below link
http://www.contextures.com/xlcomments03.html
On Fri, Aug 19, 2011 at 4:11 PM, N Pradhan nalini.pradha...@gmail.comwrote:
**
Hi,
How do you copy Cell Comments, Please help.
Regards.
--
Great Job Rajan.
On Thu, Aug 18, 2011 at 10:02 AM, Rajan_Verma rajanverma1...@gmail.com wrote:
Try the attached Workbook,
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Thursday, August 18, 2011 2:54 AM
To:
Hey Noorain,
can you tell me what is the mean of ++ and --
On Thu, Aug 18, 2011 at 10:20 AM, NOORAIN ANSARI
noorain.ans...@gmail.com wrote:
Dear Subhash,
Please try it...
=VLOOKUP(--C5,Sheet3!$A$1:$D$403,4,FALSE)
--
Thanks regards,
Noorain Ansari
Hey Subhash,
also use vlookup with value function,
On Mon, Jul 25, 2011 at 6:37 PM, Subhash Yadav scy2...@gmail.com wrote:
When I m trying to use to formula VLOOKUP against any formula generated
value, there is error.
Please suggest suitable method for the same, as I have to take many of the
)
On Thu, Aug 18, 2011 at 1:55 PM, XLS S xlst...@gmail.com wrote:
Hey Noorain,
can you tell me what is the mean of ++ and --
On Thu, Aug 18, 2011 at 10:20 AM, NOORAIN ANSARI
noorain.ans...@gmail.com wrote:
Dear Subhash,
Please try it...
=VLOOKUP(--C5,Sheet3!$A$1:$D$403,4,FALSE
thanks noorain..
On Thu, Aug 18, 2011 at 2:27 PM, NOORAIN ANSARI
noorain.ans...@gmail.com wrote:
Please see below link.
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
On Thu, Aug 18, 2011 at 2:18 PM, XLS S xlst...@gmail.com wrote:
Ok...can you give me more
which type downward or upward? and duration ?
On Thu, Aug 18, 2011 at 7:14 PM, Dinesh Prajapati
dinesh.sp1...@gmail.com wrote:
Hi,
Can some one help me to create countdown ( Day-Hour-Min-Sec) in excel.
Rgds
Dinesh
--
Hope this will Help You.
On Thu, Aug 18, 2011 at 10:11 PM, XLS S xlst...@gmail.com wrote:
which type downward or upward? and duration ?
On Thu, Aug 18, 2011 at 7:14 PM, Dinesh Prajapati
dinesh.sp1...@gmail.com wrote:
Hi,
Can some one help me to create countdown ( Day-Hour-Min-Sec
try thihs
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then Range(A2:B2).Select
If CheckBox1.Value = False Then Range(A1:B1).Select
End Sub
On Fri, Aug 19, 2011 at 3:09 AM, Bob bobandrich...@comcast.net wrote:
Please Help with code!
If CheckBox1 is Checked then Highlight Sheet2
Hey Inderjit,
please find the attachment...
On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai talk2indra...@gmail.com wrote:
Hi All,
I need your small help in Vlookup formula. I have attached a file with this
mail, where you can see 2 columns in the left. One is Qty. another is Sr.
no.
Now I
Pivots.
Best Regards,
Amit Desai
Assistant Manager, Fleet MIS (Corporate)
Desk No.: 022 40520129
Cell No.: 9867232534
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of XLS S
Sent: Wednesday, August 17, 2011 1:56 AM
Hey Satish,
please see the below link and follow instructions
http://support.microsoft.com/kb/214081
On Wed, Aug 17, 2011 at 11:36 AM, Satish Bandaru snband...@gmail.com wrote:
hi experts
please help me.plz find the atachment
thanks in advance
--
Hey Yogi,
please find the attachment.,...
there is a many way to put reverse vlookup..
like..IF count with choose functions,index with match function,lookup
function,SUMPRODUCT function
On Wed, Aug 17, 2011 at 12:03 PM, yogi yogi123 yogiyogi...@gmail.com wrote:
what is reverse vlookup.can
Hey Sundarvelan,
please try to use multiple range pivot.
On Wed, Aug 17, 2011 at 4:20 PM, Sundarvelan N nsund...@gmail.com wrote:
Hi Freinds,
Please help me to get the uniques values.
Thanks
N.Sundarvelan
9600160150
--
that's Great Haseeb.
thnx
On Thu, Aug 18, 2011 at 12:00 AM, Haseeb Avarakkan
haseeb.avarak...@gmail.com wrote:
Hi Sundarvelan,
Since you are dealing with valid numbers use SMALL function.
in G3 enter,
=MIN(B:D)
G4, copy down.
=IFERROR(SMALL(B:D,COUNTIF(B:D,=G3)+1),)
HTH
Haseeb
Hey Harsh,
Please find the below link
http://office.microsoft.com/en-us/templates/CT010144671.aspx
On Tue, Aug 16, 2011 at 1:37 PM, harsh shah harshsha...@gmail.com wrote:
dear all,
anybody having phone book software in excel ??
i.e. name contact details phone numbers up to 3 or 4
Very good venkat..
On Tue, Aug 16, 2011 at 5:03 PM, Venkat CV venkat1@gmail.com wrote:
Hi Sajid,
Look AttachedSee if it helps...
Best Regards,
Venkat
Chennai
On Tue, Aug 16, 2011 at 4:03 PM, SAJID MEMON sajidwi...@hotmail.com wrote:
Hi all Experts,
I have a
hey Vikas,
try to use batch file
open notepad...paste below code then save as
copy.bat
Copy *Comman file name*.xls output.xls
exit
On Tue, Aug 16, 2011 at 5:25 PM, vikas gupta vikas.63...@gmail.com wrote:
Dear Sir,
Sir I have a query that by
Hey Sharma,
Please find the attachment
On Tue, Aug 16, 2011 at 12:53 PM, B Sharma sharma@gmail.com wrote:
Hello to Excel Experts and other users of this group.
I've been looking everywhere about how to put several criteria in
different cell ranges in:
DSUM(database, field,
hey All,
please look into the attachment and say how to use table function with array
(table is a function or what ?)
cell F11 = {=TABLE(,E2)} what is this
..
--
ok, got it,
thnx
On Wed, Aug 17, 2011 at 5:16 AM, XLS S xlst...@gmail.com wrote:
hey All,
please look into the attachment and say how to use table function with array
(table is a function or what ?)
cell F11 = {=TABLE(,E2)} what
Also use sumproduct, and count with array
On Fri, Aug 12, 2011 at 2:30 PM, Donovan Henderson
donovan.hender...@gmail.com wrote:
Good Morning,
Attached please see time range example using the countifs function.
Regards
DH
--
great !!...thnx
On Thu, Aug 11, 2011 at 11:29 PM, ChilExcel chilexcel...@gmail.com wrote:
--
Visita ; http://sites.google.com/site/chilexcel/Home
Visita ; http://www.youtube.com/user/timextag41
--
--
Some
can u send the file..
On Sat, Aug 13, 2011 at 2:50 AM, hanumant shinde arsfan2...@yahoo.co.in wrote:
nobody has any idea abt it?
- Original Message
From: hanumant shinde arsfan2...@yahoo.co.in
To: Excel Group excel-macros@googlegroups.com
Sent: Fri, 12 August, 2011
The sender of this email is registered with Naukri.com as Future Focus
Infotech Pvt. Ltd.
*Dear Candidate,*
Dear candidates,
We have Urgent openings of VBA for our CMM L5 client for Contract to Hire
positions thru Future Focus.
we need candidates to join in max of 10 days
Req Details
VBA
Job
Hey Henderson,
Can you attach the worksheet..
On Thu, Aug 11, 2011 at 12:44 AM, Donovan Henderson
donovan.hender...@gmail.com wrote:
Good Day, Your Assistance needed:-
I have a spreadsheet showing the time of day particular categories of crime
takes place over a month. I need to now show
please see attachment
On Thu, Aug 11, 2011 at 7:28 PM, naresh v naresh.veerabo...@gmail.com wrote:
Hi friends,
I have attached one excel, can you please help me ..
Regards,
Naresh V
--
--
Some important
Hey Naidu,
Please find the attachment.
On Thu, Aug 11, 2011 at 1:47 PM, ck naidu sai21...@gmail.com wrote:
Pleae help me.
How to restrict the Special character (!@#$%^*()_+{}:?) on excel
sheet with Macros or Data validation.
Thanks
Chaitu
+91
1 - 100 of 192 matches
Mail list logo