--
Jitender
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3.
I am trying to use COUNTIF for calculating the row count for the below
condition.
COUNTIF(A1:A30,)-(COUNTIF(A1:A30,=Break)+COUNTIF
(A1:A30,=Lunch)
here in this formula i wanted to get the range of values from the
excel sheet look up column so that i dont need to change the formula
each time when
Hi Saravanan,
Two things:-
1) You can give only one criteria in COUNTIF. (For Excel 2003 and lower
version)
2) If you want to increase the calculation range, you can use OFFSET
function in Define- Name option.
For multiple criterias, you can use SUMPRODUCT or ARRAY functionality to
work more
Hi Vidyut,
Suggestion:-
If you do not have the backup of that file, then you should go and download
/ purchase some file recovery software and that will recover almost all the
data leaving some data fragments behind.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91
Hi folks,
I have this cell where the values filled can be - 0 or 1 or 2 or 3. I want
to set a custom format for excel to show -
Poor for 0
Average for 1
Good for 2
Excellent for 3
Now, I've tried and figured out that I can set maximum 03 conditions in
Custom Number format but in my case they
Dear Gurus/Friends
If you have seen my sheet .First, I want the data in each subject in a
row irrespective of session
when i get output from above i have to put data according to
session.session is to put manually.
after all things i want to rearrange data according to session and roll no
please
Dear Gurus/Friends
If you have seen my sheet .First, I want the data in each subject in a
row irrespective of session
when i get output from above i have to put data according to
session.session is to put manually.
after all things i want to rearrange data according to session and roll no
please
Dear Anish,
I dont think any lookup formula would help you in this case because
the lookup value needs to be unique and appearing just once on the
table array or else excel will consider only the first index found on
the list.
Regards,
Firoz
On Nov 13, 12:31 pm, Anish Shrivastava
I am developing a ticket managing program for a community choir and
now have generated an extensive list of ticket purchasers by name,
where some names are repeated many times over due to multiple
purchases by the same person. I would like to generate an alphabetized
list by name, a patron list,
Hi Punit,
Used Excel VBA coding in order to solve the task and attached herewith.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 11/13/09, punit poddar p2pod...@gmail.com wrote:
Hi Guys
Hi,
If the list is in Excel, then you can use below two options as per your
choice:-
1) Use Pivot Table, put the Names in Row column and the count of the names
in data field, sort the data as ascending and you have the names in
alphabetcal oder and their count in the next column.
2) If you
Dear Gurus/Friends
If you have seen my sheet .First, I want the data in each subject in a
row irrespective of session
when i get output from above i have to put data according to
session.session is to put manually.
after all things i want to rearrange data according to session and roll no
please
Dear Luc,
Not sure about OLAP pivots, but you can try below link:-
http://richardlees.blogspot.com/2009/10/excel-2007-olap-pivottable-tips.html
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
Hi Abhishek,
Unfortunately, The custom number format can take only up to two
conditions and you have three conditions in your requirement. Also,
Conditional formatting may not work as it displays colors,borders and
patterns.
I have written a macro for you which should fulfill your requirement.
Hi Friends,
I appreciate your efforts in the forum.
I have attached a workbook, I need a macro for the attached file based
on sheet(Sample1) and it should be like sheet (Sample2).
I have mentioned all details in comments.
COMPOUND |
SALT | these three fields have to split from
Hi
I need to create a macro when i put the start date and end date on a
particular Cell for the macro to filter the data only to be between
those two dates.
The concern is the fact that The coding i did do not pick the variable
dates
Sub DateFilter()
'
' Filter Macro
'
'
Dim StartDate As Date
Hi Prashanth,
You can use following formula to get the desired output.
=C3TEXT(D3, MMM-YY)
Solved workbook is also attached.
Let me know if solves your query
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New
Hi Everyone...I have a list of names (column A) and in column B I want
a formula to flag all duplicate items in column A. I was using the
formula =IF(COUNTIF($A$2:$A$10,A2)1,1,0) where 1 would flag me to a
possible duplicte (i.e. I could filter on it).
The data in column A is causing problems.
I am having a recurring problem with the default character set in
Excel spreadsheets. Without apparent cause, the keyboard characters
are changed. Where I would normally get a / I get a strange
character. Double quotations become single quotes. The only way I have
found to fix it is to close the
DEAR POOJA ,
I FEEL IT WILL BE BETTER TO PROVIDE THE SOLUTION YOU YOU COULD EXPLAIN ME
THE EXACT FORMAT OF THE SOLUTION REQUIRED. THIS IS SO BECOZ SOMETIMES YOUR
EXTERNAL REFERENCE DOES NOT HAVE WORD e- or e_OR E AT ALL , WHEREAS
ON THE OTHER OCCASSION THE SOLUTION IS 16 CHARECTER ,17 CHARECTER
Dear Mahesh,
Please use below codeIt should work now..You should also use
operators with your code. Let me know if further help is required.
Sub DateFilter()
'
' Filter Macro
'
'
Dim StartDate As Date
Dim EndDate As Date
StartDate = Worksheets(Cover Page).Range(A4)
EndDate =
21 matches
Mail list logo
