-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
exception formulas
-
J
Substitute All Except
Hi, everyone, Is there any way to substitute a character or series of characters from a cell with other characters, but with some exceptions? For example, substitute (or replace) all instances of "X" in cell B1 by cell A1, except "XP", "Xbox", "Xochitl", "Xmas", and a few others. I had written...- JRDunya
- Thread
- exception formulas if formula substitute formula
- Replies: 9
- Forum: Excel Questions
-
S
I need an exception formula
This is what I am trying to do. I have 4 core sheets that I input information into and it automatically calculates in the "monthly" and "quarterly" sheets. Right now, I place a tally mark in everyday the volunteer firefighter went to a call. Somedays they have one and some days they have five. I...- sllafleur
- Thread
- excel exception formulas forumla
- Replies: 5
- Forum: Excel Questions
-
S
Formula using "except"
Ok I have a confidential spreadsheet which is covered in formula so let me explain my problem In A1 I have current jobs In B1 I have employee on that task In C1 I have work stage E.G. Active, Complete ETC In D1 I have target completion date The formula I am using is...- scottywalker
- Thread
- exception formulas formula function
- Replies: 2
- Forum: Excel Questions
-
E
Finding Formulas in Workbooks
Hi, I need to search over 400 Excel workbooks in over 90 sub-folders for the existence of formulas entered in cells. These specific workbooks are not supposed to have any formulas in them so I’m trying to easily find any exceptions. <o:p> </o:p> How can I do this and either pipe the output...- ExcelBoston
- Thread
- exception formulas
- Replies: 3
- Forum: Excel Questions
Understanding data is crucial, and the easiest place to start is with Microsoft Excel.
This Week's Hot Topics
-
link pictures from Sharepoint to Excel macro
- Started by jc83ph
- Replies: 35
Hi, I need your help to fix this issue. I have a code and this is work on my computer. But now I try to link the picture from the SharePoint to... -
lookup match return closest to x date
- Started by 288enzo
- Replies: 35
Hi all, Happy New Year, this is my first post in 2022. I have two worksheets I'm working with. worksheet one is titled KPI Data - MY22 ONLY It... -
Average hours per week
- Started by rgillson3
- Replies: 31
I'm trying to find a simpler/quicker way to obtain the average number of hours per week for employees. My spreadsheet contains columns for Date... -
Google Sheets IMAGE Function
- Started by excelbytes
- Replies: 30
Is there any way to replicate the IMAGE function from Google Sheets in Excel? Maybe a VBA code? From what I can tell, the function in Google... -
Identify equipment used -No of consecutive days
- Started by ABC1
- Replies: 26
Hello, I appreciate your time and effort. I would like to have formula for column O and P. Column A : lots of Asset Column C: date If one Asset... -
Filling in data from source
- Started by Luke777
- Replies: 26
Hi All, I'm not quite sure what to call the following type of data manipulation so I don't quite know how to phrase my question. Below is an...
