A Microsoft Excel forum. ExcelBanter

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

Post New Thread
Threads in Forum : Excel Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
VLOOKUP questions by Auric__
I replaced this formula: =IF(AE16="v",IF(AG16="w",-5.5,-0.5),IF(AE16="ns",-0.5,IF(OR(AE16="x", ...
March 3rd 17 03:44 PM
by GS[_6_] Go to last post
5 372
Retreiving records from closed workbook by Håkan Björkström
I run a small company and have a large number of customers. I have made all customer related stuff in Excel (e.g. Invoices). Those are divided into separate...
February 20th 17 02:49 PM
by Håkan Björkström Go to last post
0 411
Shaded cells won't print shaded by Linda C
On screen cells are shaded, but on print preview and printing, they are not. Somone else created this spreadsheet, so I dont' know what she did to it. Without...
February 19th 17 11:41 PM
by Leigh-Anne Go to last post
3 6,757
Request for a Research Paper by [email protected]
Dear All, Please forward me the paper titled "The Role of Household-Level Characteristics in Predicting the Unbanked in Rural India: A Comparison of Eastern...
February 14th 17 07:14 AM
by Auric__ Go to last post
1 416
Excel Help! Multiplication Formula With A Max And Min Value by NGOULD
Good afternoon everyone! :-) I have been stuck trying to create a formula for my spreadsheet and was praying that someone could help me. I have spent hours on...
February 3rd 17 04:34 PM
by Roger Govier[_11_] Go to last post
5 651
quick annualization by billyk81
Is there any formula built into excel 2016 for quick annualization? Or do I have to go into every cell every month to update the formula for the given month...
February 2nd 17 11:18 PM
by billyk81 Go to last post
0 367
bar code scanning w/spaces by [email protected]
I've been trying to figure this out for a while, played with it - gave up for a while, but now I need to figure this out. In Excel 2007 using a Font called 3...
February 2nd 17 07:11 PM
by GS[_6_] Go to last post
1 368
Thumbs up
Calculating combinations by Beddy Boy
Hi, New user to this forum so hope I'm in right place.. I am trying to set up an excel spreadsheet when I can calculate the odds for a number of...
February 1st 17 04:47 AM
by Beddy Boy Go to last post
0 435
Problem With formula by tb
I have built this formula in cell Y4 which is used to calculate...
January 31st 17 12:04 AM
by tb Go to last post
2 373
automatically putting in dates like tuesday/thursday by [email protected]
On Thursday, May 15, 2003 at 5:53:39 AM UTC-7, John wrote: > or Monday Wednesday... > > if i enter a date in one cell and then drag the cell it > will want...
0 411
Thumbs up
Training Tracking by Irodeludo
Hi, I am pulling my hair out as the formulas on our training tracker were messed up. I have googled and tried everything that it said, but it just didn't...
January 26th 17 09:17 AM
by Irodeludo Go to last post
2 389
Conditional Formatting- highight entire row by nmb
Good morning. I have a spreadsheet with conditional formatting in it. It is almost performing as I want. However, I can not figure out how to make a rule apply...
January 20th 17 04:33 PM
by Claus Busch Go to last post
1 378
2 Attachment(s) Sort Data into new spreadsheet based on cell value by Nat96173
Hi all I am stumped on this one. I need to create a new spreadsheet based on the main data spreadsheet (see attached example). I need to sort based on a...
January 19th 17 11:24 PM
by Nat96173 Go to last post
0 426
Is there a simple formula to convert time in hundredths to minute by Ron
I get an exported excel file that has the time in hours/hundredths and I have to convert it to hours/minutes - example 6.18 = 6:11, 6.15 = 6:09, etc. I'm...
(Multi-page thread 1 2)
11 1,952
Excel 2007 sheet and workbook protection by Old Keith
In Excel 2003 I can hide worksheets then protect them so they are not visible to others. How can I do this in Excel 2007 ? I've tried hiding columns and that...
8 992
Rename Current PDF file name using Excel Sheet List by [email protected]
Hi! All, Is it possible to rename.PDF file name using excel Sheet? Basically, we are working in Tally, and we need to generate Sales Invoice from Tally, and...
2 521
Divide based on a value of another cell by Steve1971
I am new to this forum so please forgive my ignorance. I don't even know if the heading for the question is correct. Here is what I need to do. I am...
January 13th 17 02:12 AM
by Steve1971 Go to last post
0 321
Hyperlink button is greyed out. by Angie
I am working in Excel 2003 and I have a worksheet that is a table of contents with links to PDF's and Word documents. I opened up the worksheet and now some...
2 1,672
Date of the First Friday every month by [email protected]
i want to create a date table for the first Friday every month and another one for the second Friday every month and a third one for the last Friday every...
January 12th 17 11:22 AM
by Claus Busch Go to last post
6 345
How to nest functions with SUMIF function in excel by Bobito
I am trying to use 2 variables with the SUMIF function. ie:- sumif(<range1>,<criteria1>)(<range2>,<criteria2>),<sum_range> So far, I cannot find out if this is...
2 916
Post New Thread

Display Options
Showing threads 21 to 40 of 88524
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 On
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 05:48 PM.

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