Hi all,
I'm in a bit over my head with this at the moment..
I'm trying to keep track of pallet storage costs. To this end I would like to have cell D2 = sum of the cells in column C (2nd image below = seperate sheet) but only where column A = dates betw ...
Read More
| |

Good morning, everyone, I use the SI function for a point calculation based on a result. the cell referring to the computation string is on another sheet of the workbook (Points). I want to copy this formula in several lines but at each line the reference ...
Read More
| |

Hi, hoping someone can help me.
I am trying to make a sheet that reads analysis-results for me, i have different parameters within different intervals. The result varies between different intervals - giving them a surtain "class". F. eks, my result is 12. The ...
Read More
| |

Hello All,
I need to be able to extract values vertically and display them horizontally. In the attached example, I have multiple instances with the same part number but with different prices. I want to be able pull those different values (prices) verti ...
Read More
| |

In a cell in my excel sheet, this function is used
=INDEX(Bereich_Daten;AB3-3;4)
Can someone explain, what does this mean?
Thanks in Advance.
Regards,
kavin.
Read More
| |

Hello,
I have a formula that returns an array of values, and what I'd like to do is expand the formula to take that array, perform a vlookup or index/match on each value in the array to return another array, and then sum that second array.
Is this pos ...
Read More
| |

Hello,
Im in need of help.
I have a worksheet with three tabs. Tab A is my working tab. I need to perform a VLOOKUP/IF Formula to find a work task 'Maths' for example in a Column B, in 'Tab C' and pull the who row of data to Tab A
I also then n ...
Read More
| |

Trying to balance a sheet in a number value with (8) digits behind the decimal... using sum totals that derived from fractional calculations. ie... =sum (1/2*3/4*2/3*1/5*1/2). Continue to get results .99999978 or something. How can I get it to balance? ...
Read More
| |

Or perhaps another way to look at it would be how to make a formula result static...
The problem: I have created an invoicing/booking solution for my business using excel sheets, I have many sheets such as delivery addresses, client data and addresses, ...
Read More
| |

In column A, EID, I want the employee's SSN (Column D) to show up at all times. So in A4 (Alice Jones), I want her husband, who is the employee, Jim Jones' SSN should appear. Same for child. Is there a formula for this?
...
Read More
| |

I am trying to sum by color across multiple sheets.
I currently have,
example:
=sumbycellcolor('sheet1:sheet7'!b15:b27,b14)
b14 being the color
ranged between b15:b27
but i have marked error...
anyone know how to fix this?
Read More
| |

I can find no help on how to tell Excel to properly format and calculate dates before 1900. I want to calculate age at death and have birth and death dates in columns. But Excel does not recognize March 30, 1894. It calls is YYYY = 3794. And subtracti ...
Read More
| |

I'm using APIs (PowerQuery, Excel 2016) to get financial data from web that returns decimal separator as period ("."), but I need to convert it to non-English localization comma (","), which is my system default and output requirement. API input from web ...
Read More
| |

Hi, I have a complex formula that I need to write involving dates. I have students that are handing in an assignment. I have a due date column. I then have "grace" period of one week. After this for each week (period) it is overdue they receive a point (t ...
Read More
| |

Hello, i have instructions to replace any value that is 0.0% or less with a dash (-). Is there a formula to correctly format this? I do not want to lose points for simply manually entering the dash symbol into all of the cells that require a dash. Thank y...
Read More
| |

Hi. I am building a spreadsheet that can add how many days my coworkers have been active, sick, etc. I created scroll down lists with each status, and created 31 sheets for the month. A final sheet adds everything for a monthly summary. However, I cannot ...
Read More
| |

Hello, I am new to using spread sheets on Excel and am wondering how to enter the formulas to achieve the sum at the right of the columns and also at the bottom of the rows. For an example I have column C as a credit D as debt and a few more as labor debt a ...
Read More
| |

I got a test file with 10 companies. I want to calculate the median by combining TA and ROE. The objective is to find the 5 companies closest to the target company in terms of TA and then the 3 companies from those 5 which are closest in terms of ROE! I a ...
Read More
| |

similar question than last time. I'm trying to calculate the median P/E ratio of the 20 firms that are closest to the firm to be valued in terms of total assets. I got all my company (S&P 500) tickers in column C, the respective total assets in column I, a ...
Read More
| |

Hi, In Excel I have a column of "if" statements where the results are numerical values. When I go to another column and insert =sum(C4:C78) I get a zero answer. How can I add up the results in the new cell?
Read More
| |

Hello,
I am trying to get at some cross buying behavior from a large data set that I have. Attached is a simple bit of sample data and then my desired output. There is a ton of data in my actual worksheet so a formula (based off of either the Pivot Table o ...
Read More
| |

I am trying to count the number of calls I receive to a specific phone number based on the area code from which the call came. I have multiple 800 numbers for my office and therefor I need to know how many calls each 800 number gets based upon the state ( ...
Read More
| |

I need some (a lot) of help with getting information from one workbook to another. Both workbooks have a common column of item numbers. workbook1 is a master file with all available item numbers and each item's unit cost. The item numbers in workbook2 are ...
Read More
| |

So, I have created a formula with multiple "COUNTIF" functions over varied ranges. However, for a few cells within the formula, I only want the formula to count one cell or the other, but never both. So, for example, =COUNTIF(E17,">0")+COUNTIF(E24,">0") ...
Read More
| |

I am in need of some help deciding which is the correct formula to us as well as how to create iti am looking to highlight duplicate rows of information. Row1 is all titles: name (a1), address (b2), phone (C3), some of the 70 sheets I have 300 rows. I ...
Read More
| |