extra

  1. I

    Inputbox to select the range from user to apply a specific function.

    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...
  2. faeryluv

    Subtotal

    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...
  3. A

    Working out Extra hours with a limit

    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...
  4. Z

    calculation method

    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
  5. S

    Comparing text in 2 different cells

    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...
  6. P

    Text to Date Conversion

    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...
  7. H

    extract all name if certain cell has certain Text

    <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...
  8. O

    Looking for an If formula

    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...
  9. D

    Removing brackets

    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...
  10. D

    Date Formulas

    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.
  11. S

    Using TRIM with Char(32)

    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...
  12. E

    Date conditional

    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...
  13. D

    Pivot with extended table for manual input.

    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...
  14. C

    Trim column in table databodyrange?

    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...
  15. G

    VBAl only works for a small amount time before failing

    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...
  16. I

    Formula for a dozen

    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?
  17. S

    Conditional Formulae

    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...
  18. W

    work hours and extra hours

    =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...
  19. S

    Charts in VBA

    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...
  20. R

    Position(s) of the Large after multiplication

    <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...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top