forumla

Hi, I'm not overly sure how to explain this. I am creating a spreadsheet which has multiple sheets which has a summary sheet at the front which gathers data from all the different tabs. What is becoming a pain is having to rename the formulas to point to a particular tab, so, my question is...

I apologize for the long title. Here is what I am try to do. <tbody> Company Name Computer Name Connection Date Prior Activity Date Completed Date Penguins1 lab1 7/24/2017 7/24/2017 7/24/2017 Bears Inc lab2 4/23/2017 4/23/2017 1/18/2017 Bears Inc lab3 7/24/2017 7/24/2017 7/10/2017...

Okay all the big brains, I have what is probably a simple formula that has been stumping me for two days now. I did not find a specifically related thread so I'm adding this one. Problem: I want a cell to give a value based on two separate cells. The first is a standard number cell. The second...

Hi, Have a formula I think should work but it doesn't seem to be. I basically am trying to sort some top scorers by position. I have a rank sumproduct forumla that works for the ranking, but I then want to display top scorers for each position in another sheet. I have <bdo...

=C13+IF(AND(Input!B17<(Input!B5*(Input!B6/12*(MonthsOpen-1)))),C11>C13,C11-C13,0) This is my first time using excel's IF AND statements. Can anyone tell me what is wrong with this formula without looking at the actual data? Thank you

Hi there. i am looking for a formula to allocate a percentage out of 100%, to a range of values. I am evaluating 6 options (Column A) and they have different costs (Column B). I wish to write a formula in Column C that displays the cost as a %, where 0% is the least cost and 100% is the most...

Hi All, I have a table of data and I'm trying to create a gantt chart, I have looked on numerous websites, even posted on here and I still can't get it to work, can anyone walk me through the process start to finish please? Many thanks Harvey

Hi there. I'm keeping a simple score for my game guild. I need to know the difference of =A1-B1, =A2-B2 =A3-B3 etc. When I add a new column it goes to =B1-C1, =B2-C2, etc. How do I keep the formula to stay on the new column A? I've attempted to use the $ symbol but it doesn't seem to work...

Hey All, I've got some sample data here https://docs.google.com/spreadsheets/d/1T6AWBgTQyFLu2G0x4LhHCx2zjNUiXCG5i_lVTNX8X-8/pubhtml I'm renewing an existing tracker we use for 2016 and thought I could spruce it up a bit but I'm stuck with a few formulas. All the blank orange boxes at the top...

Hi Im new to Excel Forums so please be gentle with me I need some help I have some research that i have been doing for work and have just been informed by the developers that they need the data in a certain format. For example i have researched the price of a beer like Budweiser from 6...

Hi, I have a simple formula in an access query that is returning -1 instead of 10000000. Can you take a look at the formula and let me know what I am doing wrong. Its basically supposed to return 10000000 if greater than 25000 or less than -25000 RESEARCH: IIf([Change Unit...

Does anyone know if i can combine these 3 into 1? Having trouble figuring it out. =LOWER(CONCATENATE("/",C2,".html")) =SUBSTITUTE(c2," ","- ")

I have 3 work sheets within a workbook: 'RawSupplier' 'RawBalance' 'DataForMap' I need to compile data from 'RawSupplier' and 'RawBalances' onto 'DataForMap'. The Raw sheets contain customer info. I need all the data from 'RawSupplier' and only one column from 'RawBalances' showing...

Hi, I have a simple spreadsheet where I am copying over data from another sheet called 'Master Tracker' in the workbook, so each cell is just a basic ='Master Tracker'!A5 etc. However where some of the cells are blank, I want the cells on my other sheet to also appear blank instead of a zero...

I am using sheet 2 to pull data out of sheet 1. A9 has this formula in it: =(INDEX(sheet1!$G$9:$G$7000,MATCH(0,INDEX(COUNTIF($A$8:A8,sheet1!$G$9:$G$7000),0,0),0)) (it looks through column G and takes out duplicates and blanks) B9 has this formula...

Hi, I am trying to add multiple cells without having to use the (=A1+A2+A3+A4 etc) manual process, What is the quick way to do this? Thanks in advance

Hi, I'm a newbie here, and to excel at this level, and have a question I hope somebody can help with. I have a list of numbers outputted from a review of PI (the number 3.1415926535897932384......) It looks like this: 8850838032 0621312483 8327044318 1257233570 9958940293 1391776730...

Hello, I am not sure whether this is possible but ... I would like to add a Search bar to an excel document, so that you can type in all (or part) of a word and it will search the sheet for matches - then either highlight the matches or move the cursor to those cells. The document is being...

Hello All, Thank in advance for taking look. My code is very simple. I creates a summary table of important stats I need to know about data in Sheet1. shtName = ActiveSheet.Name strName = InputBox(Prompt:="Enter AOI Name, please.", _ Title:="Generate Summary", Default:="")...

Hi all, I am wondering if you could help me with the following? <tbody> A B C D E 1 Name Start Date Team Language Agent 2 Bob Smith 01/01/2014 Gareth English New 3 Jenny Lemon 01/01/2014 Ben English Experienced 4 Richard Smith 01/01/2014 Laura English Experienced 5 Steve...