I have the following code in N2
And it is showing a negative number which is correct. The issue is, I want it to show 0 if the number is negative, how can I achieve this please?
I've got a user form with a listbox and textbox.
What I'm trying to achieve is when I type things in the textbox it searches the listbox and removes anything that doesnt relate.("*" Wildcard "*") The column I want it to search in is column C and it currently has 6 columns. What is the...
Hello! looking for some help.
I have a sheet with over 2000 rows, some duplicates, some not. I am after a way to quickly edit the sheet to achieve a few things:
1 row entry for each unique item - combine the information (If info is present) in columns E, F, G & H for the row.
Here is what I...
I use Excel 2016 to produce costing sheets for projects, and I'm trying to figure out if I can get excel to automatically work out how far each customer is from a preset location e.g. a contractor. Any ideas on how to achieve it? Not sure whether it needs to be a super-techy...
I saw this post here: https://www.mrexcel.com/forum/excel-questions/712373-how-remove-consecutive-number-string-only-column.html
On how to remove consecutive numbers in a row, when I apply its suggestions I do not get any results.
I am new to VBN, can anyone help me with a...
I have a huge table (about 200.000 rows).
Now I want to split this huge table into, say, four minor tables A, B, C, and D. How can I achieve that by using VBA Code?
Thanks for your help.
I have been rying to save this problem foir weks,but am still nableto achieve what I want.
I have a column in which a value formatted to a monetary amount. However, if this is not available I want to limit the entry to "Not Known". I hav tried to nter data vlaidain to the...
So when copied down in B and pressing F9 takes litterally 10-15 mins to calculate..
I have used this before and it didnt take this long?
any suggestions as to why? or an alternative to achieve the same result?
I have a data table (columns A and B) which I could summariseusing a pivot table but don't want to as I want to perform some further work onthe data in the data table itself.
I can sum up the values for each person and can do that incolumn C using a simple SUMIF function but as you can...
Can anyone advise how to achieve a result for the following if the first vlookup fails:
I am looking to highlight two shifts on a work rota using conditional formatting but am really struggling. The shifts I am looking to highlight are 2pm to 10pm and 3pm to 11pm. How can I achieve this please?
Hi I have a list of numbers that sometimes repeat. I need to omit any value that already exists in the list from the cell above..
IE first number is column A second number is column B and where the formula is..
10 = 10
11 = 11
11 = ""
12 = 12
13 = 13
14 = 14
14 = ""
14 = ""
15 = 15
Really getting frustrated with this! Every single search for the answer seems to return an answer for achieving them same but based on rows.
There doesn't seem to be one post to achieve the same with empty cells in columns.
So this is the post i am finding everywhere:
I have a bunch of Managers (50+)with names in the wrong format, I need to get from:
Jones, Andy (L7F000915)
ABC1AJones (ABC1= site code)
not sure the best way to achieve, open to ideas.
A given table:
Depending on a value I do want to change the values in col-1, 2, 3 or 4. Lets say:
A1, A2, A3 & A4 contains the formula: IF($F$1=1;"H";"")
B1, B2, B3 & B4 contains the formula: IF($F$1=2;"R";"")
I'm hoping there is a much easier way of doing what I am doing.
Firstly, this dummy document should illustrate things.
We have our raw data (i've made the data by using another larger sheet and have about 7 queries in excel just to make it look like the first tab in the linked sheet).