Dear Prince,
Pl share a sample workbook with us.
Regards,
Gawli Anil
On Tue, Nov 20, 2012 at 8:42 AM, Prince wrote:
> Hi Paul,
>
> These numbers of columns in my array.and i wanted to assign this columns
> after transposing or after making it rows to a range.
>
> regards
> Prince
>
>
> On M
Hi Paul,
These numbers of columns in my array.and i wanted to assign this columns
after transposing or after making it rows to a range.
regards
Prince
On Monday, November 19, 2012 10:20:40 PM UTC+5:30, Paul Schreiner wrote:
>
> How are you getting 155,206 columns?
>
> In Excel 2010, there ca
This is close and might get you a kickstart.
Sub selectme()
''
'Original Script Written by www.ozgrid.com
''
Dim rRange As Range
Dim strCriteria As String, strCriteria2 As String
Dim lCol As Long
Dim rHeaderCol As Range
Dim xlCalc As XlCalculation
Hi Renu,
please find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Mon, Nov 19, 2012 at 10:35 PM, Renukachari Kasee wrote:
> Dear experts,
> is there any solution for pick the step value in certain table?
>
> please see above attached workbook
> here i need formula
I'm sorry, but that doesn't help much.
Please keep in mind that this collection of data has significance and meaning
to
YOU, but is meaningless to just about everyone else.
"how many accounts are profiled"
So, somehow these numbers represent "accounts".
But I have no idea what you mean by "profi
Hi Friends,
I have attached the file where I need to export specific range to another
excel file which to be save on C: drive.
I have created userform for this as well.
Need vba code to perform this task.
Waiting for the solution.
Please help !!!
--
With regards,
*MaNgEsH*
--
Join officia
Q: "is there any solution for pick the step value in certain table?"
I'm sure that there is.
We can easily give you answers.
lots of answers.
The problem is, they may not match up to your question.
I'm not sure what the purpose or intent is for this.
You seem to be highlighting the cell in which t
Prince, thank you for the attempt, this does not work as I intended. I'm
interested to learn more about the technique you came back with. If you
have the time can you do a quick explaination of the functions you are
using to arrrive at the result? Thank you again!
On Monday, November 19, 2012
Works Perfectly, Thanks! Rajan
On Monday, November 19, 2012 11:40:26 AM UTC-5, Rajan_Verma wrote:
> *If words are separated by Space use this*
>
> *=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),LEN(A1)*2))** *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
--
Join offici
Dear experts,
is there any solution for pick the step value in certain table?
please see above attached workbook
here i need formula for pick the value
thanks
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titl
How are you getting 155,206 columns?
In Excel 2010, there can be only 16,384 columns (and 1,048,576 rows)
So, there must be an issue with where you're coming up with that number.
Paul
On Monday, November 19, 2012 12:47:53 AM UTC-5, Prince wrote:
> Hi Group,
>
> i am getting type mismatch er
Is it Extracting 2 words??
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prince
Sent: 19 November 2012 9:56
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Formula to grab last two w
If words are separated by Space use this
=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),LEN(A1)*2))
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Natron
Sent: 19 November 2012 9:43
To: e
Hi Natron,
I hope this will help you.
=MID(A1,FIND("*",SUBSTITUTE(A1," ","*",1),1),LEN(A1))
Regards
Prince
On Monday, November 19, 2012 9:42:53 PM UTC+5:30, Natron wrote:
>
> I have a string such as the following two examples and want a formula to
> grab the last two words.
>
> The followin
Thanks Rajan
On Monday, November 19, 2012 7:09:06 PM UTC+5:30, Rajan_Verma wrote:
>
> *Transpose work only on 65536 Rows*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Beha
I have a string such as the following two examples and want a formula to
grab the last two words.
The following formula works for me but I'm looking for other ways to do the
same.
=MID(A1,FIND("-Date",A1)+6,LEN(A1))
Any help would be appreciated
Cell A1 contains:
Reporting Period: Month-T
You're welcome.
I realize that I tend to get a little verbose ("wordy"),
but different people learn things differently.
I usually try to explain the "why" instead of simply
providing a solution.
It takes more time to do it, but hopefully it
helps avoid future frustrations.
let us know if we can
Paul,
Your explanation was clear and insightful. You solved my problem.
MANY THANKS !!
On Friday, November 16, 2012 2:21:21 PM UTC-5, Paul Schreiner wrote:
> The problem is that Excel doesn't really "SEE" the hours, minutes,
> and seconds.
> What it "SEE"'s is a number.
>
> The date
Transpose work only on 65536 Rows
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prince
Sent: 19 November 2012 11:18
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Type Mismatch error.
Done !!
Regards,
Debaranjan
Thanks & Regards,
*Deba ranjan*
On Sun, Nov 18, 2012 at 9:53 PM, Ayush Jain wrote:
> Dear members,
>
> Let's get set for the new year 2013
>
> Here is inviting you to participate in a quiz to make calendar for the new
> year in excel.
>
> There are some ru
Thank you Anoop for your hlep but probably for us VBA is a not a solution.
Once again many thanks for time and effort.
S.
On Mon, Nov 19, 2012 at 9:16 AM, Anoop K Sharma wrote:
> Possibly, I am getting errors in applying the above criteria. What if I
> can provide you the same applying VBA?
>
> R
21 matches
Mail list logo
