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 » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
SAMPLE EXCEL DATA by EricB
How do I sample data in a EXCEL spreadsheet? Say I have 50.000 records and I want to sample say 0.1% or 50, what function do I use?
April 30th, 2010 03:44 PM
by Jacob Skaria Go to last post
2 150
Format a dollar amount to text by Jordan
Is there a way to take $10.56 and format it to read Ten dollars and 56 cents. Thanks in advance for your help. Jordan
April 30th, 2010 03:08 PM
by Gord Dibben Go to last post
4 258
negative value by Radhakant Panigrahi
Hi, I have below data with me, i have 4 columns where the "no of days" for Employee ID (under a particular manager ID) is coming with -ve value as well as...
April 30th, 2010 03:08 PM
by JLatham Go to last post
6 157
Multiple AND OR functions by Woodi2
Is it possible to make this function...
April 30th, 2010 01:47 PM
by Steve Dunn Go to last post
5 175
Pick List + Alphabetical Skip To or Auto Complete by Hark2k
I have an excel file with a long list of names. We have it set up to do a pick from list but we'd like to allow the user to type a letter and the list will...
April 30th, 2010 01:29 PM
by Steve Dunn Go to last post
2 189
IF formula help by Mark D
Hi Again everyone. Ok another problem I am now having. I have the following formula in column H =IF(ISNA(VLOOKUP(TRIM(A135),'Current running April...
April 30th, 2010 01:18 PM
by Ms-Exl-Learner Go to last post
2 147
VLOOKUP help (possible format issue) by Mark D
Morning everyone. I have a simple VLOOKUP calculation which is causing me problems. =VLOOKUP(A23,'Current running April 2010'!$A$1:$Q$620,1,FALSE) A23 =...
April 30th, 2010 12:50 PM
by Mark D Go to last post
6 153
counting unique text values in an array of data by selltrue
I have filtered data which contain key text with 3 possible options within each cell, how can I count the text and lookup an additional text in a column next...
April 30th, 2010 12:15 PM
by Steve Dunn Go to last post
1 156
search excel for overpopulated cells by darrick
i suspect my excel sheet is running slow due to one or more cells being overpopulated. how do i search for cells with too many characters?
April 30th, 2010 12:11 PM
by Steve Dunn Go to last post
1 115
Help with lookup by CW
Hi I need to automatically populate a colum in a table with values from a separate sheet. e.g. in table 1, I have column headings: Date; Type; Value 1......
April 30th, 2010 11:31 AM
by Eduardo Go to last post
3 152
Dynamic sheet reference in Name formula by Raj[_4_]
Hi, The name "CurrentMonth" is defined using the following formula: =OFFSET('Apr-10'!$H$5,0,0,COUNTA('Apr-10'!$H$5:$H$500),20) The workbook has 12 sheets...
April 30th, 2010 09:55 AM
by Bob Phillips[_3_] Go to last post
1 216
need to install DVZXLAddin.xla by kiran
how to install DVZXLAddin.xla in Excal 2003
April 30th, 2010 09:31 AM
by Ms-Exl-Learner Go to last post
1 185
Average If... by Nadine
I have a column of invoice numbers and multiple rows of data pertaining to each one. So one invoice number could have 10 rows of data pertaining to it so...
(Multi-page thread 1 2)
April 30th, 2010 08:42 AM
by Steve Dunn Go to last post
12 206
protection error by Selen
I have a problem with protection tool in excel. I set protection to worksheet, but it had not applied to whole sheet. Some parts can still be editing. Why...
April 30th, 2010 06:38 AM
by Jacob Skaria Go to last post
2 117
adding time in a work schedule by Chris
adding time (30 minute lunch) to a time value (6 hours) that is calculated from two cells that contain starting time & ending time EX 6:30am-3:00pm -- Chris
April 30th, 2010 05:26 AM
by Jacob Skaria Go to last post
5 183
Vlookup return 2nd match by MarkinArk
I have a quick question for you seasoned Excel gurus... I use Excel to track win/loss streaks across several major league baseball teams. I then...
April 30th, 2010 03:15 AM
by ozgrid.com Go to last post
2 123
Average IF Function by SandiVaughn
How can you test a range of cells to be greater than or less than another cell using the average if function? Ex: =AVERAGEIFS(A1:A4,A1:A4,"A6",A1:A4,"A7") ...
April 30th, 2010 02:47 AM
by T. Valko Go to last post
3 128
Adding fill to cells only when value is "No" in another cell by Noel
I would like to apply a conditional format to a selection of cells that will change the fill to gray when the value in another cell = "No". So, let's say...
April 30th, 2010 01:08 AM
by Fred Smith[_4_] Go to last post
1 161
Counting Results of Formulas by jgupte
I have a column in a spreadsheet that contains the result of a a lookup function (refering to values in another spreadsheet) and displays a blank field if...
April 30th, 2010 12:15 AM
by T. Valko Go to last post
1 164
need formula to add two different criteria in a range by Meenie
I want to count the number of "yes" in a range and the number of "n/a" in a range and get that total. If I enter =sum(if(range,"yes"+"n/a")) I get...
April 29th, 2010 11:15 PM
by Dave Peterson Go to last post
6 120
Post New Thread


Display Options
Showing threads 861 to 880 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:21 PM.


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