Oops... apologies.
I was relying only on Match with True check, which used to check less
than values.
Now, I have used simple Array with Max function to derive the required
result(s). Let me know if this helps.
Regards,
DILIPandey
On 10/13/11, BS sharma.aipl@gmail.com wrote:
Hii Dilip...
Nice collection Noorain...
Regards,
DILIPandey
On 10/12/11, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Ankit,
Please find below Short Cut keys,I hope it will help to you.
1. *Apply* an outline border
*[Ctrl]+[Shift]+[] *
2. Remove the outline border
*[Ctrl]+[Shift]+[_] *
3.
Another faster method would be
=Sheet1!$A$1:INDEX(Sheet1!$A$1:$A$1000,COUNTA(Sheet1!$A$1:$A$1000))
OR for a more expanded range
=Sheet1!$A$1:INDEX(Sheet1!$A:$A,COUNTA(Sheet1!$A:$A))
Regards,
Sam Mathai Chacko (GL)
On Thu, Oct 13, 2011 at 8:17 AM, rajan verma rajanverma1...@gmail.comwrote:
Use this formula based conditional in your Sheet 2 column A
=ISNUMBER(MATCH(INDIRECT(RC,FALSE),Holiday,0))
Regards,
Sam Mathai Chacko
On Thu, Oct 13, 2011 at 6:09 AM, Atul atul_pate...@yahoo.com wrote:
Hi,
I need your help on using conditional formatting for a cell contaning
Oops, forgot to write Holiday*s*
=ISNUMBER(MATCH(INDIRECT(RC,FALSE),Holiday*s*,0))
Sam
On Thu, Oct 13, 2011 at 11:55 AM, Sam Mathai Chacko samde...@gmail.comwrote:
Use this formula based conditional in your Sheet 2 column A
=ISNUMBER(MATCH(INDIRECT(RC,FALSE),Holidays,0))
Regards,
Sam
On Oct 12, 2011 Stuart Redmann wrote:
Hello newsgroup,
I tried the following code to create an ActiveX checkbox under Excel:
- Create new workbook.
- Add following code to worksheet 1
Sub test()
Me.Shapes.AddOLEObject Forms.CheckBox.1, , False, False, , , ,
100, 100, 100, 100
Thanks to all . almost every formula is working
Actually my problem is the following
I have 3 coloums
Rate w.e.f.
(dd-mmm-yy)Item Rate
01-Apr-10 Bulb 5.00
15-Apr-10 Bulb 6.00
01-Jul-10 Bulb 7.00
30-Jul-10 Bulb
Dear Sharmaji
Nice explanation. I have tweeked my previous formula and that worked. See
the attachment.
Regards,
DILIPandey
On 13 Oct 2011 12:23, BS sharma.aipl@gmail.com wrote:
Dilip,
I have attached a file for your reference for what I needed.
Thank you for your efforts..
Fortunately, there are smaller formulas. Here's one
=INDEX($C$2:$C$19,SUMPRODUCT(MATCH($E2$D2,$B$2:$B$19$A$2:$A$19,1)))
Here's another one that uses array
=INDEX($C$2:$C$19,MATCH($E2$D2,$B$2:$B$19$A$2:$A$19,1))
Regards,
Sam Mathai Chacko (GL)
On Thu, Oct 13, 2011 at 1:06 PM, B Sharma
Hi frineds,
can we change a hard copy of data in excel by scanner.
Regards Thanks
Anil
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hi Anil,
Could you please explain a little more. Not sure what your query is.
Sam
On Thu, Oct 13, 2011 at 3:15 PM, anil kumar kmr7a...@gmail.com wrote:
Hi frineds,
can we change a hard copy of data in excel by scanner.
Regards Thanks
Anil
--
Solution revised.
Thanks Sam for the catch.
Regards,
DILIPandey
On 13 Oct 2011 14:11, Dilip Pandey dilipan...@gmail.com wrote:
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and
Hi sam,
fist of all thanks for response. I have some data in trems of hard copy like
add. mob. no. etc.
and i have to type in excel. so i think that frist i scan that hard copy and
than change in excel file by any sofware.
I hope you will understand now.
Anil
--
Yes you can convert your image files in excel through online or download a
software from the website below :
http://www.onlineocr.net/
http://www.cometdocs.com/
http://www.coolutils.com/Online-Excel-Converter.php
http://document.online-convert.com/convert-to-pdf
http://www.pdfconverter.com/
Hi Anil,
Not sure if you are asking to edit a scanned excel sheet. Please
elaborate. Thanks.
Regards,
DILIPandey
On 13 Oct 2011 15:15, anil kumar kmr7a...@gmail.com wrote:
Hi frineds,
can we change a hard copy of data in excel by scanner.
Regards Thanks
Anil
--
Hi Group,
Please help
Thanks
Prasad.
-- Forwarded message --
From: suryaprasad...@gmail.com
Date: Thu, Oct 13, 2011 at 10:43 AM
Subject: Fw: $$Excel-Macros$$ Help required
To: excel-macros@googlegroups.com
**Hi Guys can anyone help me on this please
Thanks
Prasad
Sent from
Hi
I have an Excel sheet with VBA which is designed to compare two boxes
of text/copy and highlight any differences. The existing code is very
good although, it does not currently highlight individual words (it
only changes the box color to red to suggest there is an error).
Here is the existing
Hi,
I'm using Excel 2007.
I'm exporting some data from Oracle DB2 database using the export data
functionality in Excel (Data - Get External Data - From Other Sources
- From Microsoft Query).
To the data so retrieved, I've added two more columns which contain
formula.
Whenever the data
Dear Experts,
Please find attached data sheet I want per day per site average.
--
Regards,
Pramod Kumar
Technocare Solution(TCS)
Rudrapur
+91 9927033573
E-Mail:-kumar.pramod03i...@gmail.com
--
--
Some important
Hi
Try This Formula
=+DATE(RIGHT(A2,4),MID(A2,4,2),LEFT(A2,2))
Regards
On Oct 11, 6:08 pm, Suman ksuman1...@gmail.com wrote:
Hi,
Good evening to all,
Please help in changing date formate.
--
«•´`•.(*•.¸(`•.¸*¸.•´)¸.•*).•´`•»
«´¨*•.¸¸.*.~*--Suman --*~..*.¸¸.•*¨`»
hi folks,
I have an excel sheet wherein column A contains EMP ID and column B contains
EMP NAME.
I also have an access database with multiple forms and each form contains
this two fields also out of many fields.
I want, if the EMP ID in form matches to column A in excel then highlight
the cell.
The easy way to do this is to select the formula to copy double click the
fill handle
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Sumesh
Sent: Thursday, October 13, 2011 3:47 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ fill down formulas
Now its working...
Thanks...
On 10/13/11, Dilip Pandey dilipan...@gmail.com wrote:
Nice collection Noorain...
Regards,
DILIPandey
On 10/12/11, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Ankit,
Please find below Short Cut keys,I hope it will help to you.
1. *Apply* an outline
Hi,
Can you provide sample data.
Regards,
Swapnil.
On Thu, Oct 13, 2011 at 5:48 PM, mrinal saha mris...@gmail.com wrote:
hi folks,
I have an excel sheet wherein column A contains EMP ID and column B
contains EMP NAME.
I also have an access database with multiple forms and each form
Hi Ahmed,
I think Mr.Guillet was correct,as if i am right one cell in excel can hold
only 32,767 characters, if you have thousands of mail ids then it may exceed
this limit.
On Thu, Oct 13, 2011 at 12:34 AM, Ahmed Honest ahmedhon...@gmail.comwrote:
Dear Mr. Chethan,
Just a Lovely, Damm and
--
--
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 @ http://www.linkedin.com/groups?gid=1871310
3. Excel
Dear All,
could anyone have formula sheet with its illustration. I need it
Thanks
Regards,
Ankit
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
*Experience:* 1 - 6 Years
*Location:* Delhi/NCR
*Compensation:* Rupees 2,00,000 - 5,00,000
*Education:* UG - Any Graduate - Any Specialization,Graduation Not Required PG
- Any PG Course - Any Specialization,Post Graduation Not Required
*Industry Type:* IT-Hardware Networking
*Role:*
Dear Excel Experts (and to my friends who have answered to my
earlier queries)
From a long time, I am searching for a formula which can sort the list
and represent the unique datas only
for Example , In column 1 I have the following data
52
86
92C
94B
94B
195
193
ABC
XYZ
87
94J
94B
94K
94C
Dear Pramod,
If possible, Please explain more clearly.
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Thu, Oct 13, 2011 at 4:15 PM, Pramod Kumar
Hi
Try this .. Hope it will Resolve Your Query
*Public MyTest As Boolean
Public myWord As String*
*Sub GetText()*
*On Error Resume Next*
*Dim ws As Worksheet*
*Dim st As String*
*Dim arr() As String*
*Dim cell As Range*
**
*
Hi pramod.
Put this in E2
=(C3/B3)/D3
:)
On Thu, Oct 13, 2011 at 4:15 PM, Pramod Kumar
kumar.pramod03i...@gmail.comwrote:
Dear Experts,
Please find attached data sheet I want per day per site average.
--
Regards,
Pramod Kumar
Technocare Solution(TCS)
Rudrapur
+91 9927033573
Hi,
Do you want only 'figures' to be sorted out OR do you want numbers
only to be sorted out ?
Regards,
DILIPandey
--
Thanks Regards,
DILIP KUMAR PANDEY, mvp
MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Oct 13, 2:46 pm, B
Try this :
its not a Good Macro but can Solve your Query :
Sub bifurCateData()
Dim rngHeading As Range
Dim RngData As Range
Dim rngCell As Range
Dim strCountryname As String
Dim intLastrow As Integer
With Range(A1)
Set RngData =
Heartiest congratulations Ayush.
Sorry I missed this email.
Regards,
DILIPandey
On 4 Oct 2011 00:15, Ayush Jain jainayus...@gmail.com wrote:
Dear members,
I am proud to share that I have been re-awarded the Micrososft MVP award in
2011. My deep thanks to each group member for all your
Congratulations NOORAIN.
sorry for late responss as I was running behind on my email.
Regards,
DILIPandey
On 2 Oct 2011 00:43, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Sept'11
He has posted 140 posts
Hi,
The query is not easy but remember this group is awsome which can handle
these types of query.
See the attachment where I have tried sorting the data numeric/
alphanumeric.
Regards,
DILIPandey
On 13 Oct 2011 19:17, B Sharma sharma@gmail.com wrote:
Dear Excel Experts (and to my
Hi Rajan
Thanks so much for your speedy response.
I've added the code to my complete VBA but, it is not working. Could I
send the workbook to you for review? (it's not clear how to attach to
this thread??)
I am still very much an amateur with regards to VB!
Kind regards
Greg
On Oct 13,
What would the AFTER look like
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: B Sharma
Sent: Thursday, October 13, 2011 8:46 AM
To: MS EXCEL AND VBA MACROS
Cc: rajanverma1...@gmail.com
Subject: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)
Hi Prathap
Assuming u r value in cell A1
'=A1/10^6
HTH
Mahesh
On Thu, Oct 13, 2011 at 8:22 PM, Prathap prathap@gmail.com wrote:
Hi,
Is there a way to convert all the cells with numbers in to million format
with shortcut / formula.
Example: 1232345487 i want as 1232.
Attached is
Should do it. Or just use AUTOFILTER on the original to get one at a time to
view.
Option Explicit
Sub GetCountryData_SAS()
'fire while at Tes sheet
Dim lr As Long
Dim i As Long
Columns(I).Delete
lr = Cells(Rows.Count, 1).End(xlUp).Row
'get unique list
Range(h1:h lr).AdvancedFilter
Hi
Just divide this by 100
Try this formula =A1/10^6
Thanks and Regards,
Somnath C Pardeshi
Sent from my BlackBerry® Smartphone on Loop Mobile.
-Original Message-
From: Prathap prathap@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 13 Oct 2011 20:22:52
To:
Custom Format
#,##0,, ;[Red](#,##0,,);- ;
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Prathap
Sent: Thursday, October 13, 2011 9:52 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent Help required
Hi,
Is there a way to convert all the cells with numbers in
You could use a macro,
or, you could use a formula by:
1. Copy the sheet to another sheet.
2. in Cell D7 use: =IF('P L'!D70,'P L'!D7 / 100,0)
(If you want round it to even values, use: =IF('P L'!D70,ROUND('P L'!D7 /
100,0),0)
3. Copy this cell to all columns and rows
4. Select Copy-
Hi,
Pls find attached excel for solution.
Click on button to run the macro.
Regards,
Swapnil.
On Thu, Oct 13, 2011 at 6:18 PM, mrinal saha mris...@gmail.com wrote:
Here are both access databse and an excel file.
In access there is a object EMPDETAIL (form) contianing multiple forms.
Hi
In a cell type 100 copy it( ctrl + C)
Select all cells then paste special ( Alt + E + S + V + I ) value with divide
operation
This will convert all the numbers in million format.
Thanks and Regards,
Somnath C Pardeshi
+91 966 419 4782
Sent from my BlackBerry® Smartphone on Loop Mobile.
Dear Don other experts
Coloumn A has raw data and column B have sorted data
Before After
52 193
86 195
92C 52
94B 86
94B 87
195 92C
193 94B
ABC 94C
XYZ 94J
87
Hi,
In the Sorted list, you have shown 92C, 94B, 94C...
This is not sorted as per alphabet order and neither it is in numeric
(Descending) and same goes with 193, 195, 52, 86.
Kindly explain the order. Thanks
Regards,
DILIPandey
On 10/14/11, B Sharma sharma@gmail.com wrote:
Dear Don
Hi Prathap,
If this is one time exercise then, write 100 somewhere in and copy
it. Now select the data and apply paste special - Values - Divide.
If this is kinda template where figures will come and go, then you can
use custom format.
Regards,
DILIPandey
On 10/13/11, Prathap
Hi Group,
Need a help in Conditional formatting
I have 12 Columns in the sheet the first 6 Cols have the data and the next 6
Cols have the Checks, so based on the Values of Yes and No for the Check1
to till Check6 the values in the first 6 Columns should be highlighted
If It has Yes in the
hi prasad
pfa
On Fri, Oct 14, 2011 at 11:11 AM, Mr Excellent suryaprasad...@gmail.comwrote:
Hi Group,
Need a help in Conditional formatting
I have 12 Columns in the sheet the first 6 Cols have the data and the next
6 Cols have the Checks, so based on the Values of Yes and No for the
51 matches
Mail list logo
