YOUR FORMULA NOT SEEN
On Sat, Aug 28, 2010 at 12:06 PM, SUMIT VYAS svyas0...@gmail.com wrote:
Please enter same
On Sat, Aug 28, 2010 at 11:41 AM, Mangesh Joshi
mangeshdjo...@gmail.comwrote:
THANKS A TON
On Fri, Aug 27, 2010 at 6:42 PM, Dilip Pandey dilipan...@gmail.comwrote:
Hi
On Fri, Aug 27, 2010 at 1:43 AM, Mangesh Joshi mangeshdjo...@gmail.comwrote:
Dear All,
In Attached sheet Product column starting word *Manufacturer of *are same
in every Product colum. give me solution for that without copying how to add
this word every time.
Regards
Mangesh
--
I think excel is an application which self teach its users and allows
advance users to make its use more efficient in problem solving, quest is to
have questions aligned and faith on excel which will get the answer.
Regards
Iqbal M
On Sat, Aug 28, 2010 at 12:32 PM, solomon raju
http://office.microsoft.com/en-us/excel-help/25-easy-pivottable-reports-HA001034633.aspx
http://office.microsoft.com/en-us/excel-help/25-easy-pivottable-reports-HA001034633.aspx
http://www.timeatlas.com/5_minute_tips/chunkers/learn_to_use_pivot_tables_in_excel_2007_to_organize_data
Hello,
I am using Excel 2002 SP3 and hope to find a conditional solution
using formulas rather than a macro. In column A are a series of
values, column B has values at irregular intervals, and column C
contains calculated values based on a value in column B until a new
value in column B is
Dear Group,
Excel is the User friendly Application Compare then all Spread sheets It's
Very much Easy to Handle New user's Too..
*Best Regards,*
**
*Venkat*
On Sat, Aug 28, 2010 at 12:19 PM, Ayush jainayus...@gmail.com wrote:
Its a very handy tool for any data analysis and reporting.
Hi,
Advise needed on structuring a workbook and its modules.
I have a workbook that has become rather large over the years. The
total size of the workbook is about 6meg, of which 4.2 meg is the
modules and 1.8meg is the worksheets. For email purposes I would like
to keep the module separate from
Excel makes life simple Be it an analysis or dashboard or reports or any
daily activities.. Just Excel it.. [?]
I consider Excel as an Ocean and my knowledge is only a spoonful... I really
love it and can go gaga over it anytime and every-time...
On the lighter note: My wife calls Excel as
Oops Missed to attach the file... Now done...
On Sun, Aug 29, 2010 at 12:56 AM, Vinod N nvino...@gmail.com wrote:
Hi Vilas,
Please select column A and use Text-to-Columns under Data menu... Next
choose the desired date format from Format-- Cells option.. Solved copy of
your sample file
In addition to the above, also please check the following link:
http://chandoo.org/excel-formulas/vlookup.html
http://chandoo.org/excel-formulas/vlookup.htmlThnx
Vinod N
On Sat, Aug 28, 2010 at 8:04 PM, rajasekhar praharaju
rajasekhar.prahar...@gmail.com wrote:
Hi,
Adding to
Hi Nilesh,
There are many sites available in the internet to learn Excel.. i'm listing
only a couple.. please search for more
http://www.exceltip.com/
http://chandoo.org/wp/
http://www.contextures.com/tiptech.html
http://www.mrexcel.com/ In this site, an E-Book on Learn Excel is freely
Hi Steve,
An alternative for your query without using an Logical formula is attached.
Procedure is as under:
1. Select Column B and do Go To Special option (i.e., Keyboard shortcut
F5 or Ctrl+G and select Special Tab)
2. Choose the option Blanks
3. Now type=B1 in cell B2 and press
I am attaching a sample file, in this file, there are two column one for qty
second one for the rate. I have to separate the qty column in qty its
unit again in rate column.I have written in attach copy what format i
required in the sheet.
thanks regards
Ankit Agrawal
On Fri, Aug 27, 2010
Hi vinod,
You are not sending me any attachment please send solve attachment please
regards
Vilas
On Sat, Aug 28, 2010 at 12:26 PM, Vinod N nvino...@gmail.com wrote:
Hi Vilas,
Please select column A and use Text-to-Columns under Data menu... Next
choose the desired date format from
Is there a quick way to turn subtotaled data into permanent values,
without keeping the supporting numbers in the spreadsheet?
I'm subtotaling an inventory of products, and once I get the totaled
values and collapse the tree down to '2', I need to transfer the end
result to another worksheet or
Hello Sir,
I need help in separate the num alpha value in the one cell into another
two cells.so i am attaching a sample file in it, in sample file I have two
column and having the num and alpha value like 14.300kg or 23.30/kg so on...
and I have to separate these value in two column like 14.300
Hello Sir,
I am newly in the excel. I know only simple excel, But I wanna know about
advance excel. I have hared most Hlook Vlook but how to use i dont know.
so plz tell me what is it, what is the use of it,how it be used. and tell me
any simple and advance excel free e-book,which increase my
Hello Sir,
I need help in separate the num alpha value in the one cell into another
two cells.so i am attaching a sample file in it, in sample file I have two
column and having the num and alpha value like 14.300kg or 23.30/kg so on...
and I have to separate these value in two column like 14.300
Hi,
You have custom formatting in the both of your main data columns, which means
that only the numeric value is entered. (Select one of the cells and see what
appears in the formula bar). The units are done with the formatting. So you
only need a simple =A2 sort of formula in a cell with
19 matches
Mail list logo