A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 0.95 seconds.
Search: Posts made by: Ms-Exl-Learner
Forum: General Discussion June 6th, 2010, 11:54 AM Posted to microsoft.public.excel.misc
Replies: 3
Views: 773
Posted By Ms-Exl-Learner
Help! how to cross - data with excel??

1) Open both the files File 1 & File 2.
2) Place the cursor in B2 cell of File1 (Since the first row will have the
header - ID Number)

Press = for enabling to formula mode and type...
Forum: General Discussion June 6th, 2010, 05:41 AM Posted to microsoft.public.excel.misc
Replies: 2
Views: 498
Posted By Ms-Exl-Learner
Find certain "Text" in a specific coloum, add corres. values

Use Pivot Table. Drag and drop the Text Field in Row and the Value Field in
Data. Do double click and change the Value field in data to Sum if it is
shown as Count. Remove the subtotal if...
Forum: Worksheet Functions June 4th, 2010, 05:46 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 16
Views: 689
Posted By Ms-Exl-Learner
Counting question

May be this...

=SUMPRODUCT(($C$1:$C$200="Y")*($E$1:$E$200="AT"))

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------
Forum: Worksheet Functions June 4th, 2010, 05:37 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 5
Views: 407
Posted By Ms-Exl-Learner
Multiple IF's with an OR

You are welcome and thanks for feeding back.

--------------------
(Ms-Exl-Learner)
--------------------


"Nadine" wrote:

WONDERFUL! Thanks so much.
Forum: Worksheet Functions June 4th, 2010, 05:28 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 16
Views: 689
Posted By Ms-Exl-Learner
Counting question

You have to go as per the formula suggested by Mike Sir.

--------------------
(Ms-Exl-Learner)
--------------------


"John" wrote:

I think I stumbled onto the solution using your formula but...
Forum: Worksheet Functions June 4th, 2010, 05:27 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 5
Views: 407
Posted By Ms-Exl-Learner
Multiple IF's with an OR

Try this...

=IF(O2=N2,IF(OR(DQ2="Text1",DQ2="Text2"),IF(L20,"Yes","No"),""),"")

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------
Forum: Worksheet Functions June 4th, 2010, 05:12 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 16
Views: 689
Posted By Ms-Exl-Learner
Counting question

Check the reply posted by Mike Sir. It will get the result which you are
expecting to do.

--------------------
(Ms-Exl-Learner)
--------------------


"John" wrote:
Forum: Worksheet Functions June 4th, 2010, 04:57 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 16
Views: 689
Posted By Ms-Exl-Learner
Counting question

Please Ignore my post, since I have not read it properly.

--------------------
(Ms-Exl-Learner)
--------------------


"John" wrote:

In column A I have set of characters that are entered into the...
Forum: Worksheet Functions June 4th, 2010, 04:53 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 16
Views: 689
Posted By Ms-Exl-Learner
Counting question

Put this formula other than A&B Column cell.

=COUNTIF(A:A,"Y")+COUNTIF(B:B,"A")

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------
Forum: General Discussion June 4th, 2010, 04:52 PM Posted to microsoft.public.excel.misc
Replies: 10
Views: 473
Posted By Ms-Exl-Learner
SUMIFS

1) Check whether the AN3:AN997 numbers are formatted as Text.
2) Check whether AN3:AN997 numbers are entered with a leading single quote.
3) Check whether C3:C997 range is having the Value “ARC”...
Forum: General Discussion June 4th, 2010, 12:59 PM Posted to microsoft.public.excel.misc
Replies: 1
Views: 310
Posted By Ms-Exl-Learner
Can I display the current XLS filename in a toolbar?

May be this…

ViewToolbarsWeb.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------
Forum: General Discussion June 4th, 2010, 12:41 PM Posted to microsoft.public.excel.misc
Replies: 9
Views: 439
Posted By Ms-Exl-Learner
Conditional Formating

Actually what this formula will do?

--------------------
(Ms-Exl-Learner)
--------------------


"Going Crazy with excel" wrote:

I have developed a rule for a column of data.
Forum: Worksheet Functions June 4th, 2010, 08:30 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 8
Views: 547
Posted By Ms-Exl-Learner
How to give a string of data into different columns

Wow!!! Unnecessarily I have used Indirect, Address & Row functions. I am
laughing myself for my correction method.

--------------------
(Ms-Exl-Learner)
--------------------


"Jackpot" wrote:
Forum: Worksheet Functions June 4th, 2010, 08:00 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 8
Views: 547
Posted By Ms-Exl-Learner
How to give a string of data into different columns

Jacob Sir small correction is required.

=TRIM(MID(SUBSTITUTE("," & INDIRECT(ADDRESS(ROW(),1))&
REPT(",",6),",",REPT(CHAR(32),255)),COLUMNS($B$1:B$1)*255,255))

May I know the reason, why you have...
Forum: Worksheet Functions June 3rd, 2010, 12:18 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 2
Views: 300
Posted By Ms-Exl-Learner
Count "," in a cell

Try this…

=LEN(FO93)-LEN(SUBSTITUTE(FO93,",",""))

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------
Forum: Worksheet Functions June 3rd, 2010, 12:11 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 5
Views: 312
Posted By Ms-Exl-Learner
Transpose link

Try this…

Copy and paste the below formula in A1 cell.
=INDIRECT(ADDRESS(1,COLUMN(B1)+ROW()))

Drag it to the remaining cells of A...
Forum: General Discussion June 2nd, 2010, 11:35 AM Posted to microsoft.public.excel.misc
Replies: 9
Views: 608
Posted By Ms-Exl-Learner
Calculate the amount of time over a permitted amount (12 hours)

I assume that your data has headers, so the data should start from 2nd Row.

Copy and paste the below formula in M2 cell.
=IF($L2-$C2=TIME(12,0,0),"",($L2-$C2)-TIME(12,0,0))

Select the M Column and...
Forum: General Discussion June 2nd, 2010, 09:54 AM Posted to microsoft.public.excel.misc
Replies: 3
Views: 376
Posted By Ms-Exl-Learner
remove all duplicates?

Assume that the first column consist the Column Headers and the A Column is
having the Employee Names and the C Column is having the Participated
Employee Names.

Copy and paste the below formula...
Forum: New Users June 2nd, 2010, 08:02 AM Posted to microsoft.public.excel.newusers
Replies: 2
Views: 1,853
Posted By Ms-Exl-Learner
how can i group coloum

Please ignore my previous post.

To Group Columns:-

Select the Columns

Using Menu:-
DataGroup & OutlineGroup.

Using Keyboard Shortcut:-
Forum: New Users June 2nd, 2010, 07:56 AM Posted to microsoft.public.excel.newusers
Replies: 2
Views: 1,853
Posted By Ms-Exl-Learner
how can i group coloum

To Hide Columns:-

Select the Columns

Using Menu:-
FormatColumnsHide.

Using Keyboard Shortcut:-
Cntrl+0
Forum: General Discussion June 1st, 2010, 04:22 PM Posted to microsoft.public.excel.misc
Replies: 6
Views: 308
Posted By Ms-Exl-Learner
More on saving as binary.

Oh! Made a mistake. Please ignore my previous post. I wrongly read the
Bal001 as Ba1001.

--------------------
(Ms-Exl-Learner)
--------------------


"Ms-Exl-Learner" wrote:
Forum: General Discussion June 1st, 2010, 12:14 PM Posted to microsoft.public.excel.misc
Replies: 6
Views: 308
Posted By Ms-Exl-Learner
More on saving as binary.

I don’t think so it is a new one in Excel 2007, because since Excel 2000 to
2003 the Rows are 65536 and the columns are 256 (I don’t know about the prior
versions which is prior to Excel 2000)....
Forum: General Discussion June 1st, 2010, 09:44 AM Posted to microsoft.public.excel.misc
Replies: 2
Views: 189
Posted By Ms-Exl-Learner
Leading Zero as value not appearance

Format the cell as Text.
Select the RangeDo Right ClickFormat CellsNumberCategoryText and
give ok. Now input your leading zero value in the text formatted range.

But the Values are not...
Forum: General Discussion June 1st, 2010, 06:54 AM Posted to microsoft.public.excel.misc
Replies: 1
Views: 193
Posted By Ms-Exl-Learner
Date Related Query

Assume that your DATE SUBMITTED is in A column and the ON-TIME is in B Column.

=SUMPRODUCT((A2:A100=DATE(2010,3,8))*(A2:A100=DATE(2010,3,14))*(B2:B100="X"))

Remember to Click Yes, if this post...
Forum: General Discussion May 28th, 2010, 03:59 AM Posted to microsoft.public.excel.misc
Replies: 3
Views: 167
Posted By Ms-Exl-Learner
Help writing a formula

Insert a Blank Line or Keep the Column Title in the 1st Row and make sure
that your data should start from 2nd Row.

Once again repeating you, that the data should start from 2nd Row.

I am using...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 08:06 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.