excel

I have a dataset that spans around 50+ columns, however the names are all under a cell in row 2 separated by commas. Example: For A2, you can see the full string as its the same in each cell in E2, I can use Data > Text to Columns and separate this fine into row 3 for instance. Then using the...

I have a random question for any MS excel wizards out there, does anybody know what formula to use in order to track my current loan amount in excel? So if I give an example if I had a loan of £4000 and was repaying £100 a month I want excel to know which month it is currently now and minus...

Not that you need to know but let's start over as my post didn't save when I clicked back from the preview :cry: So.... I have a staff rota that tracks the number of days someone has worked and on another sheet based on the number of days worked the number of total hours worked. The query is...

Hey all, I need some help in working out a column of numbers which I'm adding up a cumulative total... so let's say the column has 30 expected values and I only have the 3rd so far e.g. 3000, 3000 and 4000. This is displayed as, which I have done already: 3000 6000 10000 I need to display in...

Hey all. So I have to work out my staff's sickness days and calculate their Bradford Factor score. However, this is done on a rolling 365 days from the day I work this out. I tried searching online but most of it was setting up rolling calendar dates in the future. I need a way of working this...

I have the logic in my head though I can't work out if it's best to go in rows or columns. I've tried both and it adds all. So I'm trying to count simply what days staff has done overtime working out if it's weekdays or a weekend. I'm using the following format from M3 onwards Sat | Sun...

Ok, so I've managed to show 3 different graphs but wonder if it's possible to have all 3 graphs in one... I'm jotting down the temperatures across 3 rooms, 3 times a day. Let's say morning, noon and evening. Now in Power BI, I can show the day on the X-axis and one of the rooms on the Y-axis...

Hey all, I'm trying to work formula to see if a staff was in, it will show their shift hours if its Mon-Thu or Fri. I've listed the shift times in 2 columns. I'm using as an example, =TEXT(F5,"ddd") to display the weekday. So the following formula works where it checks conditional formatting on...

Hello All, I've trying to write a vlookup from another worksheet that will pull through the visit, date and weight given only the name (there are columns between the example above in the real version) I've no doubt foolishly tried the below and get a #Spill! error (where "VS" is the other...

Hello, Under what's new for Windows 10 October update this excel template is provided: https://templates.office.com/en-gb/family-tree-generator-tm89758537 I have tried to look behind it to see how the "calculations" are done but can find any behind the scenes formulae etc. e.g. how does it...

I've got a google sheets spreadsheet which i have multiple 'sums' on it. How can i repeat those sums down the columns without it filing in Zero's all the way down? If i don't 'drag' the formula down (and get all the zeros!) it means having to individually drag down the 'sum' on every cell i...

I'm currently studying medical science, we don't really use high task programs. I mainly use word, excel and adobe (for digital text books). Non-uni activities would be limited to just youtube/netflix/web browsing. This device is entirely aimed at low level tasks, no gaming or editing software...

A weird and highly disruptive thing has just started to happen, and I've searched for the last hour for how to fix it, to no avail. When I type = into a cell in Excel (quite an important part of Excel) the keytips appear (the little black boxes hovering over the ribbon / quick access that lets...

Hi Everyone. Does anyone use PowerBI? Specifically Waterfall charts? I need some assistance with how it interprets data. From my own experiments, it seems that waterfall charts will only display combined data and I was wondering if I might have set it wrong, id like to show something granular...

Hi all, We've a spreadsheet that is used by 3 or 4 people in the company, constant issues with 500 errors popping up. Clearing cache and cookies, opening in a new tab seems to be the only way to deal with the problem but it's not always a 100% fix. They do edit at the same time, all in the...

Hello, I am having some trouble trying to make my spreadsheet formulas work in an excel spreadsheet on dispatch times. The idea was; i would have two sheets (Times (sheet1) & Data (sheet2)) Sheet 2 Data; would have lots of various destinations: Column A - Location 1 Column B - Location 2...