extra

Hi All, I have following VBA code to remove extra hidden characters from a range. It works fine. But many times I need to change the range for removing extra hidden characters and for this everytime I have to go edit the macro. I want an inputbox to be appeared to select (from user) the range...

I'm using the Subtotal function, and that works good for what I'm doing, however, I don't need all the extra rows. Without the Subtotal function, I'm manually adding up the duplicate orders and then deleting the extra rows. Example Row 1: route 1 item D4 order 50 Row 2: route 1 item D4 order...

OK i have been racking my brain about this for far too long, hopefully someone here can help me What i need is a formula that will tell me how many extra hours someone has worked over their contracted hours, So the Min would be their Contacted Hours Per Week * 4 (32*4=128) the Max would be 160...

hello, i would like to know if there’s an equation to help me automatically calculate/multiply any extra 1 percent after 100% with 1.5 as factor for the extra 1 percent

Hi It is easy to do the above as per https://exceljet.net/formula/compare-two-strings. My question: Can one do such a comparison without extra spaces in one cell being counted in the comparison? In other words, if the only difference between the 2 cells is an extra space in a sentence, I...

I have a column that has an extra "1" at the start. The requirement is to strip that extra character/number and convert the date to a MM/DD/YYYY format. Column A 1140430 1141124 1140403 Column A 14/04/2030 14/11/2024 14/04/2003 is there a VBA way to do this, preferably without creating any...

<tbody> A B C D E F G H I J K L M N O 1 NAME SUNTIME SUNP0S MONTIME MONP0S TUETIME TUEPOS WEDTIME WEDPOS THUTIME THUPOS FRITME FRIPOS SATTIME SATPOS 2 JOHN 4-12 POS1 4-12 POS4 4-12 POS4 4-12 POS4 4-12 POS4 4-12 POS4 4-12 POS1 3 BILL 6-15 POS2 6-15 POS1 6-15 EXTRA 6-15 EXTRA 6-15 EXTRA...

I am looking to use a IF formula but not sure how to write it so it returns the value i want. I have a list of SKU's that have a location by them, i also have a separate list of locations. I want the If formula to return a value of 1, if the SKU's location appears in my 2nd list...

Can someone help me with this function, I am trying to remove the RoundDown feature from the formula but it is not liking the brackets that I am removing. How should it look? The formula is...

I am currently using the following formula to get dates: =IF(ISBLANK(A22),"",IF(C22="Y",D22+18,WORKDAY(I22,1,Holidays!$B$1:$B$5))) If I get more than 2 dates, for example 07/16/2019 four times, is there a way to add 1 day to the extra 2 dates? I do not want to have more than 2 of the same date.

Hi folks, I have 2 pieces of data that are both amalgamations of data from other sheets on the same workbook in the following way: =A1&"/"&B1&"/"&C1 The data is: A1 FOC01/FOCAL POINT/C and B1 FOC01/Focal Point /C The difference being the extra space in B1 This is just a sample of the data...

Hi, Can someone please help me with this formula? I have this info: Column A = employee name Column B = hiring day Column C = Original vacation days per year (15 or 20) **Column D = Xtra vacation days Column E = Total vacation days (15+column D) For every year worked after 4 years...

Hi everyone, I would like to ask on how to make extra rows on a pivot table?. I've seen this one excel file which there is a Pivot table and on its right side there's an extra rows that you can enter data on it. It looks like a part of Pivot table but right clicking on its cells and headers...

So as discovered earlier I have an issue with extra spaces when I bring in data from another souce file. What I want is to be able to, using VBA script, trim all extra spaces, specifically after the text. My data is in a table titled "PasteTable" I have tried every solution I can think of...

Hi Everyone. Having an issue with my vba below. Our developers every now and then (as per normal) update our system (crystal reports) by adding or deleting extra columns, I export these reports to a CSV Excel file then run my macro on the csv to delete and manipulate the columns and data...

I have a qty in Column E. I need a formula that will divide by 12 and then count the extra. I have 66 in Column E. I need 5 (for 5 cases of 12) in column G and 6 (for 6 extra boxes) in column H. Can anyone help with this?

Hey all, I'm making a spreadsheet for the users on my Discord server, so they can identify fanartists who accept commissions, and calculate which prices they want. https://docs.google.com/spreadsheets/d/1skPQhzpjgW2dogUINUCV47Pv-TBFdcKxdZ9NsMdjObY/edit?usp=sharing I'm providing a google...

=IF(G2<=8,G2*$J$2,IF(G2<10,8*$J$2+(G2-8)*1.25*$J$2,IF(G2>10,8*$J$2+2*1.25*$J$2+(G2-10)*1.5*$J$2)))+IF(C2=6,G2*1.5*$J$2-G2*$J$2,0)+IF(C2=7,G2*2*$J$2-G2*$J$2,0) C2=6 C2=7 6 and 7 are the days. it works fine with 8 hours work, but more than 8 years it doesnt work the terms are: work 1 hour- 43.5...

I am working on constructing charts with VBA within a For loop. There are two main problems I am facing. The first iteration generates a chart with five data series despite my intention of including only two. One is a multiple range source, and the other two are 1 values. On the second...

<tbody> </tbody> In my example I've got components of 5 combinations in B5:C9 to be multiplied, Extra is added to each of the B5:B9 and C5:C9 array(s) when calculating the Largest product of those arrays. Instead of listing the results of the multiplication I'd like their...