Hi group,
Greetings!
Please refer the attached excel sheet.
We know that a bubble chart is a three dimensional chart, X, Y and bubble size.
I want to add one more dimension to it (one more factor). This will be
represented by a specific colour of the each bubble.
For example, 1 represents red bubbl
Sheets("Sheet1").Range("a23:a65536").EntireRow.Delete
where "Sheet1" is Name of Sheet
--
*Arif Mansoorali Massani
Gujarat, India*
On Wed, Aug 11, 2010 at 7:55 PM, dii jii wrote:
> Hi,
> Would like to get a piece of code ( excel macro) to delete Columns
> starting row 23.. This is where my
Hi Angelo,
I'm still confused about exactly what you want. Are you really sure you're
looking for an iteration?
You say that If in cell A1 i have "aaa" it should stay the same, but if i
have "bbb" it should be changed to "ccc" , but cell A1 *has* "aaa" or *
displays* "aaa"?
- If it has "aaa", then
Dear Bruno,
Thanks for the feedback.
If in cell A1 i have "aaa" it should stay the same, but if i have "bbb" it
should be changed to "ccc".
Regards
2010/8/11 Bruno Bruno
> Hi,
> I am not pretty sure of what you want, but aren't you looking for a simple
> formula? Something like:
>
> =IF(MOD(
I really would like to do this using a formula or code instead of
filter or pivot. Let me just explain again and you will understand
formula makes much better sense. Basically, what I really want to do
is have a drop down listing of all 50 states where the user will pick
a state and than you will
Hi Noorain,
Vlookup cant do this.. However u can use the Offset and Match formula
combination to do this..
The following link has the solution...
Look at the section "Left Lookups"
http://www.cpearson.com/excel/TablesAndLookups.aspx
Regards,
Andy
On Wed, Aug 11, 2010 at 2:46 PM, NOORAIN ANSARI
Thanx Ramkesh..
but its not..what i wanti explain..what i do...i have 6lac data in
access with all details...and on daily basis i have reced. some mobile nos
and after that i check all detail in access with running query..after
running query..output copy and paste in excel on front of that mob
Hi,
Would like to get a piece of code ( excel macro) to delete Columns
starting row 23.. This is where my headers start.
I don't want include the entire column, i ahve some data above row 23.
Thanks in advance.
Jimmy
--
---
Dear balbir,
You can use EOMONTH function..
=EOMONTH(DATE,No. of Month)
Thanks,
Noorain
On Wed, Aug 11, 2010 at 4:44 PM, balbirkumar . wrote:
>
> Dear Friends,
>
> I want to add months to data which is in date format.
> please suggest me the way out.
> I have got data in date format as 25/
a dedicated "search" you have 72 names to search for if then else 72 "if
thens"
and iterate your loops for next one to 72
On Wed, Aug 11, 2010 at 8:41 AM, Raj Kumar wrote:
> Hi,
>
> This is a attachment. I want to separate words on the base of Capital
> Letter so kind suggest me that how can we
Dear Kalyan,
Please see attached sheet..Most Probably your problem has
been solved
Thanks,
Noorain
noorain.ans...@gmail.com
9911176564
On Wed, Aug 11, 2010 at 4:26 PM, Kal xcel wrote:
> Hi,
>
> I have this data in a sheet
>
> *Depot Name* *BP Name - Report*
> Ahmedabad H K Sales
Hi,
This is a attachment. I want to separate words on the base of Capital Letter
so kind suggest me that how can we separate this records.
Regards
Raj Bharti
--
--
Some important links for excel users:
1. Follow us
Hi Kalyan pls use Pivot table u can see like the date below.
Count of BP Name - Report Depot Name BP Name - Report Total
Ahmedabad H K Sales Agency - Sanand 1 Parshwa Traders - Gandhinagar 1 Soham
Agency - Chikhli 1 Ahmedabad Total 3 Ambala Chaman Traders - Ambala 1 Happy
Traders
Thanks for replying sudhir,
I understand your suggestion. But I was looking for a macro solution to it.
Because sometimes the data may cross to thousands of rows and then it
becomes very difficult to do it manually.
Regards, Bikram
--
Hi,
I am not pretty sure of what you want, but aren't you looking for a simple
formula? Something like:
=IF(MOD(CODE(A1);2)=1;A1;REPT(CHAR(CODE(A1)+1);3))
Where A1 is the cell with "aaa"
On Tue, Aug 10, 2010 at 6:23 PM, Angelo Spinola wrote:
> Hello,
>
>
> How can i create and iteration for:
>
Hi,
No. VLOOKUP only works left to right.
If you want to work right to left, you have to use Index / Match
Regards - Dave
Date: Wed, 11 Aug 2010 14:46:31 +0530
Subject: $$Excel-Macros$$ Can we find left Value through VLOOKUP formula..
From: noorain.ans...@gmail.com
To: excel-macros@googlegr
Hi,
If you have the Analysis Tool Pack loaded, use EDATE. It's very
straight-forward.
If your date is in A1, then in another cell: =EDATE(A1,50). Format using a Date
fromat.
If you don't have it loaded, it comes with XL. Tools menu, Add-ins, tick
Analysis Toolpack.
Regards - Dave.
Date:
Dear Friends,
I want to add months to data which is in date format.
please suggest me the way out.
I have got data in date format as 25/06/2008 and i want to add 50 months to
this date. Please advise
With
Thanks & Regards
--
Balbir Kumar
--
Hi,
I have this data in a sheet
*Depot Name* *BP Name - Report*
Ahmedabad H K Sales Agency - Sanand Ahmedabad Parshwa Traders -
Gandhinagar Ahmedabad Soham Agency - Chikhli Ambala Chaman Traders - Ambala
Ambala Shiv Trading Company - Assandh Ambala Happy Traders - Barara Ambala R.
K. Gene
Dear Experts,
Can we find left Value through VLOOKUP formula..Please need your
co-operation..
Example...
I want to find Emp Name behalf of Emp ID through only VLOOKUP.
Emp Name
Emp ID Noorain 22330 Sunil 22331
--
Thanks & regards,
Noorain Ansari
noorain.ans...@gmail.com
--
Hi Practice Practice,
Open the file in Excel. You will find all the information
autofit the data
Select all and then Use Text To Columns Feature in Excel.
Choose the Delimited option. And the the Next Screen you will have a place
to type a customized delimiter.
Type the Pipe symbol in that and clic
HI Aftab,
U can use filters.
On 8/11/10, Mukesh Kukreja wrote:
>
>
> i hope it will resolve ur problem, if not pl let me knw what exactly u want
>
>
>
> On Wed, Aug 11, 2010 at 12:50 PM, ALAM wrote:
>
>> DEAR ALL,
>>
>> I WANT TO MAKE A MIS REPORT OF ATTANDANCE AS PER DATED.
>>
>>
i hope it will resolve ur problem, if not pl let me knw what exactly u want
On Wed, Aug 11, 2010 at 12:50 PM, ALAM wrote:
> DEAR ALL,
>
> I WANT TO MAKE A MIS REPORT OF ATTANDANCE AS PER DATED.
>
> REG
>
> I WANT TO DETAILS ACCORDING TO EMP-ID, JUST FOR S
Hello,
Attached sheet contains data in column A where data in each cell is
separated by ( | ). I want to separate out the data into multiple rows
without overwriting.
For example:
Column A contains the data
Row1:US20100081275A1
Row 2: CN101682937A_ | JP2010506381A_ | KR2009071614A_ | US2008008
DEAR ALL,
I WANT TO MAKE A MIS REPORT OF ATTANDANCE AS PER DATED.
REG
I WANT TO DETAILS ACCORDING TO EMP-ID, JUST FOR SELECTED
IMP-ID
PLS FIND AN ENCLOSED FILES
--
Regards&Thanks,
AFTAB ALI
9310903589
--
---
Thanx!! Flemos
On Sat, Aug 7, 2010 at 2:50 PM, Deepak Rawat wrote:
> Hi all
>
> I have attached a file containg pivot table with some data.
> I have two qurries
> 1. I want to put a foruma next to pivot table and want to copy and paste
> all formula to all rows but its taking freezing cells by
I guess these are in ColA and ColB. In ColC =CONCATENATE(A1,B1), then
sort, then filter unique values.
Or the counties are all different? If so sort the counties only,
combined and find unique values.
If the above not work, then code. let me know.
David
On Aug 9, 1:06 pm, daruM wrote:
> Hello,
Thanks dude.
It works.
Best Regards,
PRATHAP D
M +91 9899-370-328
On 9 August 2010 19:26, Bruno Bruno wrote:
> My friend Prathap,
>
> Yes, there is. I did it in the Sample I am returning to you, but I would
> strongly recommend other simpler ways to do it.
>
> The point is that up to Excel-0
Hi Rajesh
We can import the data from the web,
"Click on Data Tab --> From Web" (in office 2007)
Regards
Rajender Soni
On Aug 10, 8:17 pm, Rajesh Nair wrote:
> -- Forwarded message --
> From: Rajesh Nair
> Date: Fri, Aug 6, 2010 at 1:27 PM
> Subject: CAN HTML file Connect to E
Hi
Please find attached the solution.
Regards,
Rajender Soni | +91 750 322 55 50
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2.
30 matches
Mail list logo