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
Vlookup returning a YES or NO by Rob
Hello I'd like to return a yes or no response. at the moment only the YES is working. Can anyone give me a...
September 18th, 2008 02:30 AM
by Héctor Miguel Go to last post
6 94
Fill Down reference of even number rows by jyorraku
I have Excel 2002, I need to reference only even number row coordinates, and I would like to do it with a fill down: =B4 =B6 =B8 =B10 ... ...
September 18th, 2008 12:48 AM
by Ron Coderre[_3_] Go to last post
3 78
converting vertical inches in tank to gallons (have manual chart) by Scotty[_3_]
I have a tank that I measure daily to see how many gallons are in. I measure it with a stick and then look at a chart made for the tank to see how many...
(Multi-page thread 1 2)
September 18th, 2008 12:48 AM
by Pete_UK Go to last post
14 158
Pulling partial information from a cell by Emeryville John
Hi, Thanks to Dave and Peo for help on my previous request. I have a list of 5 digit zip codes (eg. 90210) and a list of 5 + 4 digit zip codes (eg....
September 18th, 2008 12:30 AM
by Ron Coderre[_3_] Go to last post
2 147
Need a Sum but involves Text & multiple functions by v!v
Hi - Trying to turn a simple informational table into a math question here. The initial table includes the following which were initially handentered: (First...
September 18th, 2008 12:23 AM
by v!v Go to last post
4 172
nested subtotal with sumproduct by SteveDB1
howdee all. Last month I'd asked about nesting a subtotal function with a sumproduct. While my initial question was answered (the way I could explain it), I've...
September 18th, 2008 12:05 AM
by SteveDB1 Go to last post
0 120
VLookup multiple values - sum returned values into single cell by se7098
I have found several items close to what i need but nothing exact. I need to perform a vlookup consisting of multiple values (names of cities) then return...
(Multi-page thread 1 2)
September 18th, 2008 12:04 AM
by T. Valko Go to last post
11 390
Need help summing time by ascottbag-hcm
Can anyone please offer help with summing the following example in excel so that my result is returned in hours, minutes and seconds? The cell format...
September 17th, 2008 11:17 PM
by Peo Sjoblom[_2_] Go to last post
6 196
Mix text and numbers with leading zeros by Susan B
Good morning, Trying to create barcodes by putting text (W0410) plus 08, plus a five digit number beginning with 000001 and incrementing by 1. The leading...
September 17th, 2008 11:03 PM
by Susan B Go to last post
3 118
Combining functions: Subtraction and IF by Jeguth1s
I am trying to combine 2 functions. I need the formula to first calculate this: =C3-K3. Based on the value returned i need to combine it with the formula...
September 17th, 2008 10:58 PM
by T. Valko Go to last post
1 121
Concatenate with carriage return- how to remove blanks? by cindyc
I'm trying to concatenate 15+ columns into one and have the results appear in list format- so I've used =concatenate(a1,char(10),a2,char(10),a3........
September 17th, 2008 10:31 PM
by Gord Dibben Go to last post
3 151
Address can not be more than 30 characters by NeSchw6G
Hello, I have a report that is opened through excel and it includes an address column. I am sending this report to a thrid party who can not have the...
September 17th, 2008 10:20 PM
by Don Guillett Go to last post
7 143
Last Friday of the month by Alfredo_CPA
I have in cell "A5" the last day of the month (i.e. las month was 08-31-08 and this month will be 09-30-08) I need a formula in "A6" (that works for every...
September 17th, 2008 10:16 PM
by T. Valko Go to last post
9 141
Hybrid vlookup - sum function by Emeryville John
Hi, I have two tables that each have 2 columns. The first column in the first table is composed of dates that are in ascending order, but have some...
September 17th, 2008 09:37 PM
by Dave Peterson Go to last post
2 119
Vlookup by mary/payroll
I have two spread sheets. One has employee benefits 09/12 and the other has employee benefits 09/19. I want to compare the employee benefits and they are...
September 17th, 2008 09:29 PM
by mary/payroll Go to last post
0 93
sumif or sum production - 3 or more criteria by James
Excerpt from my s/s A C I N pipe steel no grade size grade jonts ...
September 17th, 2008 09:27 PM
by Teethless mama Go to last post
5 111
A mysterious if function to return a specific balance? by hankach
Hello everyone, If A1=Debit; B1= Credit; C1= Sold A2=100; A5=50; A7=10 B3= 20; B4= 50; B6= 40; B8=40 C2=A2; C3=C2+A3-B3; C4=C3+A4-B4; C5=C4+A5-B5; C6=...
September 17th, 2008 09:07 PM
by hankach Go to last post
2 201
need formula to count non-zero items in an array based on a vlooku by BKP
I would like to count the number of #'s 0 from B$2:cell(vlookup(A1,A2:B7,2) A B 1 Sep-4 2 Sep-1 10 3 Sep-2 0 4 Sep-3 5 Sep-4 5...
September 17th, 2008 08:55 PM
by BKP Go to last post
2 129
Linking Workbooks by crimlaw73
Ok here goes.......I work in Quickbooks for 5 different companies. Every month I export the company financials from Quickbooks into Excel. Once in Excel that...
September 17th, 2008 08:43 PM
by crimlaw73 Go to last post
0 135
Complicated Countif application by mpenkala
Hi there, I'm in need of some help... here's the problem. In ColumnA I have a list of numbers (thousands) ranging from 0 to 50. What I need to do is count...
September 17th, 2008 08:29 PM
by mpenkala Go to last post
4 130
Post New Thread


Display Options
Showing threads 20261 to 20280 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 11:31 AM.


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