excel novice

Novice here.. Can anyone help with the below formula? It seems to be working for the first condition but not the second IF.. Column BC contains the values 'Y', 'N', and blank. So the second IF should run if BC is not 'N' (BC would be 'Y' or blank) IF(BC2 = "N", U2="NO"...

Hi all, I am trying to find a way where I can return a value within a cell based on specific text. My cell contain the below data. Dear Victorian Power Networks - Rural, SPEAR: S178918T Responsible Authority: Greater Customer City Council Application Type: Certification Property Address(es)...

Hello Verse, I have been recently instated as the inventory management person while we are trying to digitize our daily checklist. I have more then a few asks. First up is going to be: Can I use the conditional formatting that already exists within the workbook as a reference to pull that...

Hi guys :), Hope you are all well. I have ran into a major issue with my spreadsheet not pulling the correct data, which is meaning my whole spreadsheet is failing now. I am praying someone on here will be able to help me :). If you look at sheet 1 (attached) You can see that row 4 shows all...

I do a LOT of scheduling people at my job. Kronos spits a nasty excel sheet with 1000's of rows and about 40 columns. I've got created enough macros to where it fine tunes it to what you see below BUT I would like to do a few more things to really make it so I can print these schedules for staff...

Hi people! This is probably so easy for most of you and I imagine you could do it in your sleep, however after fiddling around I've still gotten no where. I have an excel sheet, with around 30,000 columns and quite a lot of rows about Pro Cycling and how I rate their performances. Column one...

Ok so I'm a novice at Excel so be easy on me! So I have a spreadsheet and I need to add an amount up.. It's hard to explain so for example. I have someone pays me £200, I need a box where I can enter £200 and it'll add up in the box next to it.. When I press enter I need box I typed £200 in...

I have a master 'all office' worksheet where all data for all offices is entered, there are 15 offices that each have a sheet containing the same data pertaining to the individual office as that on the 'all office' sheet. Up until now I've been using a series of VLookups to update the...