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
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...
Yesterday 05:33 PM
by Claus Busch Go to last post
1 20
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)
Yesterday 08:33 AM
by soicaulobachthu1 Go to last post
12 1,472
Exclamation
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...
Yesterday 08:31 AM
by soicaulobachthu1 Go to last post
1 36
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 589
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...
7 163
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 13th 17 09:48 AM
by TheSunriseBay Go to last post
8 87
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...
January 13th 17 09:47 AM
by TheSunriseBay Go to last post
4 1,436
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 03:12 AM
by Steve1971 Go to last post
0 20
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 658
sumif function in excel by Basil
Hi, I need assistance with a download that has text in two seperate columns, referencing general ledger account numbers. I need to reference these columns in...
5 498
custom number format code using letters and numbers by Foo Foo Daddy
How can I format my cell to display letters, a dash, then #s? For example: ABC-12345678, or 2DE-12347562, or FG3-46518673?
(Multi-page thread 1 2)
December 26th 16 01:33 PM
by Thế45363 Go to last post
15 1,845
Calendar on multiple sheets by Antoine Balon
Hello, I have to create a schedule of employees for the year 2017. I fairly new to excel. How do I create a calendar on multiple sheets automatically with the...
December 20th 16 04:53 PM
by GS[_6_] Go to last post
1 222
LINEST with r2 = -1.18 ??? by [email protected]
Hi all this is funny. Missing values are a problem with LINEST However, the very Excel that does not allow for missing values, ignores them when plotting a...
0 172
Adding a max percentage to existing formula by JedSrq
I have the following example where the second column calculates 10% for every age. But when I get to an age over 5, I want the formula to only calculate a...
December 17th 16 11:50 AM
by bdshl009 Go to last post
4 295
Round up by 0.5 if >=.25, down to integer if <.25 by [email protected]
Hi there, what would be the formula to take above criteria and apply to numbers from 1-6, for results like this: 4.15 would be 4.0 4.35 would be 4.5 4.65...
(Multi-page thread 1 2)
December 17th 16 11:38 AM
by bdshl009 Go to last post
10 368
Unhappy
AVERAGE with multiple conditions by AaronR
Hello, I'm trying to calculate an average, but need to adhere to a couple conditions: - Average must be of A and B - A is capped at 125% - B is capped at...
December 17th 16 11:19 AM
by bdshl009 Go to last post
7 281
1 Attachment(s) Sum columns based on conditions by shani1975
Hello, I need to figure out how many "true" Regular employees we have. As you can see, I have columns that are labeled FT, PT, REG, SEAS and INTERIM. A FT...
December 17th 16 11:13 AM
by bdshl009 Go to last post
2 220
Lock Cell After Data is Entered on Particular Cell by Moideen
We are maintaing an excel sheet for expense details, After Entering the data on Amount Coloumn Need to Lock The Amount Coloumn with Password. Please help...
(Multi-page thread 1 2)
12 2,263
How to put space in between each Character in same cell with formula by Sunil V
Hi, How to put space in between each Character in same cell with formula For example: ABCDEF which is in A1 Cell should be converted in to A B C D E F need to...
December 9th 16 03:50 PM
by DungSports Go to last post
7 280
Formula That Checks For Changes by tb
I have a spreadsheet with the following columns: * Col. A: Part numbers * Cols. B, C, and D: Current data that pertains to part numbers in col. A * Cols....
November 30th 16 06:58 AM
by Claus Busch Go to last post
7 517
Post New Thread


Display Options
Showing threads 1 to 20 of 88501
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 03:10 AM.


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