Posts by Ingo_Ingo


    How can I do this:

    In cell A1 is 5.00 in B1 will be 5.00

    5.00 remain 5.00
    5.19 becomes 5.5 (everything after the point and range between 5.01 and 5.49)
    5.50 remain 5.50
    5.83 becomes 4.00 (everything after the point and ranges between 5.51 and 5.99)

    I made a long formula with IF, MOD and INT. Can somebody made formula for that?

    Re: Count Specific Day Name Between 2 Dates

    Quote from Baodad;644199

    I arrived here after Googling for how to find how many Mondays there are in a month. My solution is below. No UDFs, no array formulas. Mine only counts the number of Mondays in a month. I haven't tested it thoroughly, but it works for the 7 months I did test it on. I'm posting it here because others may be able to adapt it to their needs.


    How many Mondey is in a specified month.
    Something like is this formula:

    = 4+(DAY(A1-DAY(A1)+35)< WEEKDAY(A1-DAY(A1)-1))


    Re: Time format hh:mm:ss.000

    Quote from venkateswaran;642235

    Thanks all for ur effort. got the solution by using below formula.
    = LEFT(TEXT(A1,"h:mm:ss"),LEN(TEXT(A1,"h:mm:ss"))-4)

    Venkateswaran K


    It's good that you answered this year :)
    Solution found is text and you can not do any further calculations.

    Happy New Year.


    In Sheet1 A1: AP1 have names of regions. Under the name of each region (ie in A2: An) are localities in that region. Meeting is a userform that will display combobox1 regions, a combobox2 they will be displayed depending on the selected region localities in combobox1 and a textbox that will be displayed postal codes of the localities.
    Postal codes are in Sheet2. In odd-numbered columns starting with A2, C2 etc are names of localities and in even-numbered columns are postal codes of the locality.
    May be empty cells in column postal codes
    Can anyone guide me or help me with VBA code.
    Thanks in advance to all who help me.