gratefully

I have a spreadsheet with formulas in certain cells - for example in B2 I have =IF(A2="","",(B1)) but if I enter a date in A2 nothing appears in B2 unless I select B2 and click the fx button and okay the box that appears. I did read to check that I hadn't selected Text for these cells but I...

Hi, I have a spreadsheet for work with bookings in it, there’s multiple columns but I need to transfer data from one cell to another based on the following IF column A has a certain date in it AND column B has a certain time in it AND column C has a certain word in it then I want it to take...

Hi, I have values in cells A1 to A100 A value may look like =1234-4561+456-123 or =456+987 Or even 1234 My aim here is to give each individual value it's own cell So assume my first example is in A1 then my aim is for B1 = 1234 C1 -4561, etc. Any help given would be gratefully...

Hi, I am looking for some help with an Excel formula (unsurprisingly) I have 4,000+ rows of data in the format below. Every row only has one result in one of the year columns. I am looking for a way to combine the rows into something like in the second image, and have been tearing my hair out...

hi all i am trying to output a list from column A depending on the contents of cells in another column column a Contains Names and the other columns all contain numbers i wish for one list, from column A, to be produced based on if the number in column C is less than 20 and then the same for...