Is there a way to define a listbox entry. So that the defined entry
could represent an abitrary group of cells or a defined range?
So say I create a defined range that has A3,A5, B2,B3,B4 and called it
Group1.
Could I in the listbox entry create a name say NewName that epresent
the defined group
Hi
If you are using Excel 2007 then
1. Right-click on the status bar ( Excel 2007)
2. You will get Average, Count, Sum option
3. Select Sum
The sum will be displayed in the status bar.
Thank You,
On Thu, Jun 17, 2010 at 2:23 PM, anu naik wrote:
> Hey Guys,
> I need help in a matter
Hi,
If you are speaking about Status bar that you cant find the sum, Then right
click on Status Bar and select SUM;
Hope ur issue is resolved
Best Regards,
Guru.
On Thu, Jun 17, 2010 at 2:23 PM, anu naik wrote:
> Hey Guys,
> I need help in a matter
>
>
> While using excel ,the sum is display
Hi,
Try using =CONCATENATE(C2&D2) in Column E and then the Vlookup in F.
It should work.
Best Regards,
Guru.
On Thu, Jun 17, 2010 at 2:54 PM, Regina Medhanie
wrote:
> Thanks you. I try your suggestion and give both cell the same format
> but still I get # N/A. The cell I am refering contains
I am a beginner of VBA in Excel. Can anybody tell me good VBA book
which will help me to learn it from scratch?
Book should be simple to study.
Thanks
--
--
Some important links for excel users:
1. Follow us on TWITT
hi Deepak,
This file has been shared. Please remove sharing (tools-->share workbook)
and then Pivot will start working.
regards,
Vijay
On Wed, Jun 16, 2010 at 10:59 PM, Deepak Rawat wrote:
> Hi friends,
>
> I got an excel file, in which pivot table option is disable and not
> working. But i am
Hi Dave,
I was able to use your solution and already have it implemented!
Everybody is really happy:-) Thank you so much for the help!
I also wanted to thank Alvin and the others who have also provided
suggestions and solutions. What a great group!
Thanks, again,
Kristin
On Jun 17, 4:03 pm,
Hi Friends,
I know the all excel funstions very well except Macro.
Anyone tell me how i can learn macro very well in short time or..where i can
start to learn the marco in excel.
need you help and suggestions.
--
Your's
Surendra
--
Hi Dave,
Greetings from the US! This looks to be exactly what I need! Now,
just to figure out how to implement it in my existing spreadsheet,
which is a shared doc for numerous people to access...is it possible
to start with your setup and change/add my real list data? I'll begin
working with i
