date:20140325

Re: $$Excel-Macros$$ Fwd: Lists Output request

2014-03-25 Thread priti verma

for first query try thi with CSE
=SMALL(IFERROR(IFERROR(SMALL(IF($C$5:$C$14<>$B$5:$B$14,$C$5:$C$14,""),ROW(INDIRECT("1:"&$C$5:$C$14))),IF($B$5:$B$11<>$C$5:$C$14,$B$5:$B$11,"")),""),ROW(INDIRECT("1:"&COUNTA($C$5:$C$14

and for second try this wit CSE
=SMALL(IF($C$5:$C$14<>$B$5:$B$14,$C$5:$C$14,""),ROW(INDIRECT("1:"&$C$5:$C$14)))


On Wed, Mar 26, 2014 at 11:21 AM, Ahmed Honest wrote:

> Dear All:
>
> Please see attach excel file and if you can help me with a formula to
> generate OUTPUT in 2 different ways from List 1 and List 2.
>
> *Thanks in advance!*
>
> --
> *Ahmed Bawazir*
> *احمد باوزير*
>
>
>
> --
> *Ahmed Bawazir*
> *احمد باوزير*
>
> --
> 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 RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Macro help needed

2014-03-25 Thread ǝɹohsiʞ ʞ ʌ d

Hello Rafael,

check the below sub and call the sub @ 'Need help here to do something with
the data collected from Sql Server


'
*
Private Sub WriteDate(rs As Recordset)
On Error GoTo ErrorMessage

Dim objWorkBook As Excel.Workbook ' Initialize the workbook object
Dim objSheet As Excel.Worksheet ' Initialize the Sheet object

Set objWorkBook = ActiveWorkbook  '.Application .Add ' Assign the
workbook object to excel application object
Set objSheet = objWorkBook.Sheets.Add ' Assign the Sheet object to
workbook object with Sheet1

objSheet.Activate ' Activate the Sheet object
colCount = rs.Fields.Count ' Get the reocrds field count
rowix = 1 ' Set the row count to 1

While Not rs.EOF ' Open the While Loop until the Record Set object has
records
If rowix = 1 Then ' Write the Column Name to the activated Workbook
sheet
For i = 0 To colCount - 1
objSheet.Cells(rowix, i + 1) = rs.Fields(i).Name
Next
rowix = rowix + 1
End If

For i = 0 To colCount - 1 ' Write the data to the activated
Workbook sheet
objSheet.Cells(rowix, i + 1) = rs.Fields(i).Value
Next

rowix = rowix + 1 ' increament the row index by 1
rs.MoveNext  ' move the record set object to next value
Wend

Set objWorkBook = Nothing ' make workbook object to nothing
Set objSheet = Nothing ' make sheet object to nothing
Exit Sub ' exit the method

ErrorMessage:
'Resume
MsgBox Err.Description
End Sub
'
*

Let me know if it helps?

Thanks and Regards
Kishore


On Wed, Mar 26, 2014 at 3:11 AM, Rafael DeLeon wrote:

>
> Hello all,
>
> I have a SQL Server Database with a store procedure that I would like to
> display in excel. I'm able to connect to the database through excel using
> VBA, but don't know how to display the information in a spreadsheet. Any
> help or idea will be appreciated.
>
> Thank you,
> Rafael
>
>
> Bellow the code that already works:
> Sub GetData()
>
> Dim con As ADODB.Connection
> Dim cmd As ADODB.Command
> Dim rs As ADODB.Recordset
> Dim par As String
>
> Set con = New ADODB.Connection
> Set cmd = New ADODB.Command
> Set rs = New ADODB.Recordset
>
> Application.DisplayStatusBar = True
> Application.StatusBar = "Contacting to SQL Server..."
>
> ' Log into SQL Server, and run the Stored Procedure
> con.Open "Provider=SQLOLEDB.1;Password=***;Persist Security
> Info=True;User ID=password;Initial Catalog=DataTest;Data
> Source=192.168.2.196\Test"
>
> cmd.ActiveConnection = con
>
> Dim prmCustomerID As ADODB.Parameter
>
> ' Set up the parameters
>
> cmd.Parameters.Append cmd.CreateParameter("@From", adDate, adParamInput,
> 10, Range("B4").Text)
> cmd.Parameters.Append cmd.CreateParameter("@To", adDate, adParamInput, 10,
> Range("B5").Text)
>
> Application.StatusBar = "Pulling data from Store Procedure"
> cmd.CommandText = "spParticipationRpt"
> Set rs = cmd.Execute(, , adCmdStoredProc)
>
> 'Need help here to do something with the data collected from Sql Server
>
> rs.Close
> Set rs = Nothing
> Set cmd = Nothing
> con.Close
> Set con = Nothing
>
> Application.StatusBar = "Process completed successfully."
>
> End Sub
>
> --
> 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 RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem,

$$Excel-Macros$$ Fwd: Lists Output request

2014-03-25 Thread Ahmed Honest

Dear All:

Please see attach excel file and if you can help me with a formula to
generate OUTPUT in 2 different ways from List 1 and List 2.

*Thanks in advance!*

-- 
*Ahmed Bawazir*
*احمد باوزير*



-- 
*Ahmed Bawazir*
*احمد باوزير*

-- 
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 RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Lists123.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Need Book for Web scrpting by vba excel

2014-03-25 Thread pramodb35

Hi Excel Expert,

I am Pramod. Any have idea that any kind of book available in market for 
Web scrpting by excel vba
I am newly developer of excel vba. and also suggest me that can i use macro 
recorder  code in my real code. And give me suggest that how can i expert 
in vba programming.

I will look forward for ur appreciate help.

Thanks 
Pramod
VBA Developer  

-- 
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 RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Code that passively identifies users who opened a workbook

2014-03-25 Thread Rob Flott

I am trying to determine the code that would (passively) record the users, 
within our company, who are using a selected workbook.
 
Is this feasible and if so how do I write it.
 
Thank you,
 
Rob

-- 
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 RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Excel Add in

2014-03-25 Thread Divaker Pandey

 Excel (2007) intermittently adds the full pathname of the add-in to the
function name when it's used in a cell formula. Then if the spreadsheet is
opened on another computer, even if the other computer has the add-in
installed, the function is not recognized. Any idea how to solve this?

Divaker

-- 
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 RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Excel

2014-03-25 Thread Kene

I have a database and want to populate data into cells from another sheet 
in the same database in excel, any suggestion how I can go about this?
 

-- 
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 RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Need Formula

2014-03-25 Thread Vabs

Hi

you can do using combination of Index & Match function.

Thanks


On Tue, Mar 25, 2014 at 5:42 PM, Deepak Rawat wrote:

> Hi,
>
> is there any solution in someproduct formula to get intersect text value
> in 2D range:
>
> Below is the data;
>
>Bran Model - 1 Model - 2 Model - 3 Model - 4  Audi A4 A6 A8 A10  BMW Series
> 3 Series 5 Series 7 X6  Mercedes A Class C Class E Class S Class
> Brand Model Answer   BMW Model - 2 Series 5
>
> --
> 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 RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Need Formula

2014-03-25 Thread Divaker Pandey

i think you want

=VLOOKUP(B7,$A$1:$E$4,MATCH(C7,$A$1:$E$1,0))



On Tue, Mar 25, 2014 at 5:42 PM, Deepak Rawat wrote:

> Hi,
>
> is there any solution in someproduct formula to get intersect text value
> in 2D range:
>
> Below is the data;
>
>Bran Model - 1 Model - 2 Model - 3 Model - 4  Audi A4 A6 A8 A10  BMW Series
> 3 Series 5 Series 7 X6  Mercedes A Class C Class E Class S Class
> Brand Model Answer   BMW Model - 2 Series 5
>
> --
> 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 RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Need Formula

2014-03-25 Thread Deepak Rawat

Hi,

is there any solution in someproduct formula to get intersect text value in
2D range:

Below is the data;

   Bran Model - 1 Model - 2 Model - 3 Model - 4  Audi A4 A6 A8 A10  BMW Series
3 Series 5 Series 7 X6  Mercedes A Class C Class E Class S Class  Brand
Model Answer   BMW Model - 2 Series 5

-- 
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 RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Contacting Servers

2014-03-25 Thread Abdul Razack

Dear Team Members,

This is my first query to the group.

I have some excel files, when we i try opening, it says contact servers :
xyz...

and it goes on and on, some time it takes 10 to 15 minutes.

Just wanted to check how do i disable this

I use MS office 2013.

below is the screen shot for the same.




-- 

Thanks & Regards

Abdul Razack
9738674192

-- 
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 RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Text Cleaning

2014-03-25 Thread Ashish Bhatnagar

www.quickdatacleansing.com is an online data cleansing solution.

The need for data cleansing is made clear when considering how easily 
errors can be made. In a database of names, addresses or contact numbers, 
for example,

- Name might be entered as Bobby John¼23son.
- Address may be 143$2!^&a,/ random stree@@$t
- Contact nos. may contain alphabets or special characters like 123ab@#456.

Such variations are most likely an error. If you are dealing with such type 
of error then www.quickdatacleansing.com is the right website to cleanse 
your data and fix it online, instantly within seconds, and under just 
nominal cost. May be most of your basic issues in data cleansing gets 
solved.

Thanks.
Ashish Bhatnagar

On Monday, June 4, 2012 8:44:34 PM UTC+5:30, SG wrote:
>
> Hi,
>  
> This is my first post in this group.I have learnt many things from this 
> group.I'm finding difficulty in cleaning the range in which each cell has 
> string like " rahul;6e3-".I need a macro which will clean the special 
> characters,spaces & numbers & leave the alphabets only.
>  
> Thanks in advance.
>

-- 
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 RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: data cleansing

2014-03-25 Thread Ashish Bhatnagar


www.quickdatacleansing.com is an online data cleansing solution.

The need for data cleansing is made clear when considering how easily 
errors can be made. In a database of names, addresses or contact numbers, 
for example,

- Name might be entered as Bobby John23son
- Address may be 143$2!^&a,/ random stree@@$t 
- Contact nos. may contain alphabets or special characters like 123ab@#456.

Such variations are most likely an error. If you are dealing with such type 
of error then www.quickdatacleansing.com is the right website to cleanse 
your data and fix it online, instantly within seconds, and under just 
nominal cost. May be most of your basic issues in data cleansing gets 
solved.

Thanks.
Ashish Bhatnagar

On Wednesday, October 30, 2013 4:36:42 AM UTC+5:30, Diamond Dave wrote:
>
>  I have a situation where I down load data and delineate results leaving 
> a name with blanks behind the number making a Vlookup difficult.
>
>  
>  
> ASIAN HONDA MOTOR CO.,LTD. 
>
>  
>
> The name above is an example.  Is there a formula I can use to remove any 
> blanks behind the last character?
>
>  
>
> Your help as always is appreciated.
>
>  
>
> Regards
>
>  
>
> Dave
>  
>  
>   
> *Visit*
>  
> *http://www.excelvbamacros.com/ *
>  
>  
>  
>  
>  
> P Before printing, think about the environment.
>  
>  
>  
>  
>
> -- 
> Join official Facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>  
> FORUM RULES
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
> members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel...@googlegroups.com
> .
> To unsubscribe from this group, send email to 
> excel-macro...@googlegroups.com .
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>  
>  
>  

-- 
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 RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

2014-03-25 Thread Deepak Rawat

Thanx for your kind suggestion, i am trying to learn the VBA



On Tue, Mar 25, 2014 at 2:17 PM, Divaker Pandey  wrote:

> need to use both procedure for your requirement, you were using only one.
>
> and please try to learn vba wtih programming skill.
>
> it will help you understand other's program and you can also modify
> according your need.
>
>
> On Tue, Mar 25, 2014 at 10:38 AM, Deepak Rawat wrote:
>
>> Hi,
>>
>> Could u see the error..
>>
>> Regards
>>
>>
>>
>> On Sun, Mar 23, 2014 at 6:29 PM, Deepak Rawat wrote:
>>
>>> i tried the code but giving ubound error, sample is attached,
>>> kindly check
>>>
>>>
>>> On Sun, Mar 23, 2014 at 6:19 PM, Deepak Rawat 
>>> wrote:
>>>
 Hi,
 i tried but not working but showing #Value! Error

 Pls look into...

 Regards,
 Deepak


 On Thu, Mar 20, 2014 at 5:33 PM, Divaker Pandey wrote:

> use below code
>
>
> Sub sortCellsValue()
>  Dim tempStr As String, resultSet As String
>  Dim tempstrArr() As String
>
>  Dim i As Integer
>  For Each cl In ThisWorkbook.Sheets("Sheet1").Range("A2:A271")
>tempstrArr = Split(cl.Value, ",")
>tempstrArr = removeDuplicate(tempstrArr)
>For i = 0 To UBound(tempstrArr)
> For j = i + 1 To UBound(tempstrArr)
>  If (Trim(tempstrArr(i)) > Trim(tempstrArr(j))) Then
>  tempStr = tempstrArr(i)
>  tempstrArr(i) = tempstrArr(j)
>  tempstrArr(j) = tempStr
>   End If
> Next
> Next
>
> tempStr = Join(tempstrArr, ",")
>
>   cl.Offset(0, 1).Value = tempStr
>  Next
>  End Sub
>
>
> Function removeDuplicate(tempstrArr() As String) As String()
> Dim i As Integer, j As Integer, count As Integer
> Dim newArr() As String
>
> For i = 0 To UBound(tempstrArr)
> For j = 0 To count
>  If (Trim(tempstrArr(i)) = Trim(tempstrArr(j))) Then
>   Exit For
>   End If
>   Next
>   If j = count Then
>ReDim Preserve newArr(count)
> newArr(count) = tempstrArr(i)
> count = count + 1
>End If
>
> Next
>
> removeDuplicate = newArr
> End Function
>
>
>
> On Thu, Mar 20, 2014 at 3:44 PM, Deepak Rawat  > wrote:
>
>> Hi Dipanke,
>>
>> One more query i have, please do me favor
>> I have lots of cells which contains duplicate comma desperated values
>> like given below
>>
>> Audi, BMW, Audi
>> BMW, BMW, Toyota
>> Honda, Toyota, BMW, Honda
>>
>> After cleaning it should be look like below:
>>
>> Audi, BMW
>> BMW, Toyota
>> BMW, Honda, Toyota
>>
>>
>>
>> could duplicate value be deleted by macro, kindly help
>>
>> Regards,
>> Deepak Rawat
>>
>>
>>
>>  On Thu, Mar 20, 2014 at 2:40 PM, Divaker Pandey > > wrote:
>>
>>> use this macro
>>>
>>>
>>> Sub sortCellsValue()
>>>  Dim tempStr As String, resultSet As String
>>>  Dim tempStrArr() As String
>>>  Dim i As Integer
>>>  For Each cl In ThisWorkbook.Sheets("Sheet1").Range("A2:A271")
>>>   tempStrArr = Split(cl.Value, ",")
>>>
>>>For i = 0 To UBound(tempStrArr)
>>> For j = i + 1 To UBound(tempStrArr)
>>>  If (Trim(tempStrArr(i)) > Trim(tempStrArr(j))) Then
>>>   tempStr = tempStrArr(i)
>>>   tempStrArr(i) = tempStrArr(j)
>>>   tempStrArr(j) = tempStr
>>>  End If
>>> Next
>>> Next
>>>
>>> tempStr = Join(tempStrArr, ",")
>>>   cl.Offset(0, 1).Value = tempStr
>>>  Next
>>>  End Sub
>>>
>>>
>>> On Thu, Mar 20, 2014 at 2:30 PM, Deepak Rawat <
>>> deepakexce...@gmail.com> wrote:
>>>
 yes but its very time consuming to do mannually sort...



 On Thu, Mar 20, 2014 at 2:26 PM, VJ IR  wrote:

> Have u tried using text to columns??
>
> Its a simple way to do so.
>
> Regards,
> Vijay Iyer
> On 20 Mar 2014 14:23, "Deepak Rawat" 
> wrote:
>
>> Dear All,
>>
>> I have attached a sheet with rawa data  & final data.
>>
>> I need a macro to sort coma separated data in each cell, like
>> example is given below:
>>
>> NDTV, BBC, Aaj Tak, Facebook we need to change it as below
>>
>> *Aaj Tak, BBC, Facebook, NDTV*
>>
>> i have lots of data to sort, but not getting any solution to do
>> quickly
>>
>> Thanks & Regards,
>> Deepak
>>
>> --
>> 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
>

Re: $$Excel-Macros$$ Fwd: Lists Output request

Re: $$Excel-Macros$$ Macro help needed

$$Excel-Macros$$ Fwd: Lists Output request

$$Excel-Macros$$ Need Book for Web scrpting by vba excel

$$Excel-Macros$$ Code that passively identifies users who opened a workbook

$$Excel-Macros$$ Excel Add in

$$Excel-Macros$$ Excel

Re: $$Excel-Macros$$ Need Formula

Re: $$Excel-Macros$$ Need Formula

$$Excel-Macros$$ Need Formula

$$Excel-Macros$$ Contacting Servers

$$Excel-Macros$$ Re: Text Cleaning

$$Excel-Macros$$ Re: data cleansing

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

14 matches

Site Navigation

Mail list logo

Footer information