1. G

    Split value in half and add

    <tbody> A 500 B 750 C 750 </tbody> How can I split A in half and add the half (250) to B & C to equal 1000 or it can not be done? Thanks in advance GT
  2. W

    Next due date in FY 2019-20 based on frequency of payment & start date

    I want help with formula for calculating first payment date falling under period 01/04/2019 to 31/03/2020 based on frequency i.e. Annual, Monthly, half Yearly, Quarterly from any date. e.g. Start date- 05/08/2012 ( it can range back to year 1950) Frequency- Half yearly/Quarterly Result...
  3. N

    Opening multiple instances of Excel

    I've recently migrated to Windows 10 and am using Excel 2019. When I open a second sheet it is opened in the same client instance as the first. I've edited the registry to prevent this (there are some guides on that on the Internet) and this works but only when I run Excel by itself, not when I...
  4. R

    Formatting issue

    Hi all, I have created a table for the football team I run to show goals scored in first half, second half and complete game (in a win/lose/draw format) as I want to see if there are any patterns in the data and also have linked to an overview chart for each. The first half and second half...
  5. F

    Format part of cell with underline

    Is it possible to format half of a cell with a different format? I'm using =TEXT(G5,"0.00")&CHAR(10)&TEXT(E5,"0.00") and would like to format the first half with an underline so it looks like a division. Like this 1267.98 66.21
  6. L

    Rearrange Data

    Hi, I have data in this format: <colgroup><col><col><col><col></colgroup><tbody> CID "C-00001" "C-00002" "C-00003" Name Alexandra Van de Vyvere Nathalie Pouradier Duteil Thomas Raguenaud Waist 75 79 88 Half Waist Front 39 40 Half Waist Back 37 39 Hips 92 98 104 Half Hips Front...
  7. danhendo888

    How to fix these dates?

    https://1drv.ms/x/s!AvjBsEPEq12ngTwwKMwIFJo5_Tk7?e=J87rl6 How best could I go about fixing this column so that it shows dates. The bottom half is in text format. Thanks all.
  8. Y

    Stopping A Looping of Files At Half Way

    I am reading a bunch of text files in a folder through loop. Using possibly a command button, how can i halt the loop half way instead of waiting for it to complete before i can do some other things.
  9. M

    Countif function to count as a half

    I have a Key Section see belowH = 1 Full day holidayHD = 0.5 half day holidayI am trying to pull this into a summary sheet to add up. Each staff names are in rows with each have a cell under Jan to a total Holidays, but it adds H as 1, and HD as 1. When I want it to record HD as 0.5 half day...
  10. F

    How to calcuate YTD Sum with Quarterly/Half Inserts

    Hi there - I am working on a file where expenses are listed by month. However,within that range, there are quarterly and half sums. So the range looks like: J, F, M, Q1, A, M, J, Q2, H1, J,A, S, Q3, O, N, D, Q4, H2, FY Looking for a way to calculate year to date expenses, excluding the...
  11. D

    How to change the lenght of a connector ?

    Dear all, Does anyone know how to adapt the lenght of a connector. Here the present code allow to draw a connector for the above border of a current cell, but I would like it a little bit longer. AddConnector(msoConnectorStraight, .Offset(, 1).Left, _ .Top + .Height / 17...
  12. G

    Formula based in Header

    Hi Guys, So i have a very long formula with 1,269 characters. Basically, it is composed of multiple ifs, mathematical operations inside and outside of parenthesis. I have set it up so long ago in specific columns. I've even added this to vba so that it'll autopopulate in my worksheet. A =...
  13. P

    Mixed Date Formats in the same Column

    I have a big spreadsheet, some 750000 rows. In Column C I have dates. Approximately half of the dates in this Column are in dd/mm/yyyy format, the other half in mm/dd/yyyy format, I think. eg. 31/05/2012 then 01/06/2012 (appears as 06/01/2012 in the formula window) Any help to get them ALL...
  14. D

    Auto clicking macro button

    Hi Sub Button1_Click() Range("T23").Select Selection.ClearContents End Sub Sub test() Application.OnTime Now + TimeValue("00:00:10"), "Repeat_VBA" End Sub Above is the code I have. I have created a button which when clicked manually clears the contents in T23, as seen in the top...
  15. Z

    converting date format

    Hi, I have half a spreadsheet with the date format in the mm/dd/yyyy, followed by the other half with the format I need: YYYY.mm.dd I tried converting it but couldn't do it. ANy ideas? Thank you!
  16. S

    Calculating 0.5 leave days

    Hi, I have created an annual leave calendar with drop down lists for each day making it possible to select the type of leave (annual leave (1day) and annual half day leave (0.5day), in a table below I have a summary where the annual leave for each month is added up, providing an annual total at...
  17. B

    Seeking help in forming an excel formula

    A kind of leave called commuted leave is credited half the half pay leave (another leave) every year. While commuted leave is credited maximum 30 in a service period, half pay leave is credited 60 in a service period (15 every year). Now if E13 = Half Pay Leave Credit, H13=Commuted Leave Credit...
  18. B

    Excel formula

    A kind of leave called commuted leave is credited half the half pay leave (another leave) every year. While commuted leave is credited maximum 30 in a service period, half pay leave is credited 60 in a service period (15 every year). Now if A1 = Half Pay Leave Credit, B1=Commuted Leave Credit...
  19. E

    Need help with VBA code to enter specific content in a fixed number of cells

    Hi, Can someone please help me with a VBA code for the following: 1. Suppose I have around 1000-2000 email ids in Column A 2. I need to assign content for eg. "Car" to half of these ids in Column B and "Motorbike" to the other half. Appreciate any help!
  20. E

    1 Hour

    Hi, I want that when I copy and paste time in Column C, an extra hour is added automatically. I mean if time is 7:35, when paste time will automatically be 8:35. This is about starting the second half of a soccer game. https://yadi.sk/i/69TRVQvw8zVzoA

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...