i.e

  1. A

    convert number to time format

    I'm looking up the city UTC time zone. Some cities have negative numbers versus positive numbers. When it is found, I trying to convert the number into a time format (i.e. -5.5 = -5:30). However, when a number is negative and I convert it into a time format, the number is not being displayed...
  2. J

    date time forumla

    Hello to all, I need to find a formula that will take two dates and two different time ( time in and time out) and subtract them to give me the time what was the balance used I.E Date time in date completed time out time used 5/1/2018 10 AM 5/2/2018 11: PM...
  3. D

    Converting cell data with a formula

    If there is data in a cell that is formatted as '3yrs 6ms 23ds' and links to another cell in another workbook and I want the cell in the other workbook to display this period in days i.e. 1302, what formulae would you use? Many thanks
  4. C

    Link to a file name with a cell value

    Hello, I have 2 files. file 1 collects information from multiple files, just numbers. i want to be able to type in a person's name in file 1, and have it use that name in multiple formulas in that file to grab different cells in file 2. i.e. ='c:\temp\jonsmith_file.xlsx'!C1. I want to be...
  5. A

    Userform Frame Scroll

    Is there any way to scroll a frame on a userform when the screen used is a touchscreen? i.e. swipe to scroll, not tapping scroll bars.
  6. C

    Searching for patterns of text with VBA

    Hi there, How do I search for a pattern of text in cell using VBA? I've looked into the instr and find method but this still eludes me. For example, I've got a list of clients with special IDs attached next to their names. (i.e. John Smith ABC1234). How do I search the cells to determine...
  7. S

    Nested IF? Maybe AND? Both?

    Hi all, I know this is a breeze for some of you, but I'm struggling a little. I have values in G3 and H3. I'm trying to calculate the following If G3 is < H3, make the cell appear blank with "" else If G3 / 2 is < G3 - H3 G3 / 2 else G3 - H3 i.e. G3 H3 14 6 Result of formula would be 7...
  8. D

    Looking for some direction: Use of Spreadsheet (worksheets) vs VBA functionality

    I have a Excel spreadsheet that consists of 6 worksheets. I include the following simply to provide a little background in preparation of asking a couple questions. The worksheets are as follows: Tennis Roster - max 20 players Schedule - For Tennis Doubles (i.e., 4 people needed to make up...
  9. P

    How do I save a macro as XLSB without any Worksheets?

    XLA used to be just the macro and no worksheets, but I cannot find a way to save XLSB without any Worksheets i.e. just the macro?
  10. E

    Four Digit Possibilities

    Hello, I’m looking for the total number of possibilities for a four digit entry where: 1. Available digits = 0,1,2,3,4,5,6,7,8,9. 2. Any single digit can only be used once. 3. Any combination of four digits are equal and only counted as one possibility (i.e., 0123, 3210, 1230, 2130 etc...
  11. D

    Noobie with pivot table

    Hi guys! I like Excel a lot and have been using it for years, however always got through without pivot tables and relied just on formulas. Should still be the case with the following quest (SUMIF?), however I feel I have to try out a pivot table sooner or later. I have a somewhat easy...
  12. N

    VBA Help

    Book1ABCDEFGH1Name1-Dec8-Dec15-Dec20-DecAverageCurrent week - Avg%2Cognizant$5$4$4$9$4$5108%3Credit Suisse$6$7$8$10$7$343%4Dominos$3$6$7$8$5$350%Sheet1 Column A have Name Date starts from Column B1 and is dynamic i.e. depending the no. of dates, the range will differ from B1 to X I want to...
  13. P

    nestedif or only if condition

    Sir, I am getting 12 lakh rupees annual salary. While paying tax, for 1st 2.5 lakh tax is nil. For next 2.5 lakhs 5% tax i.e. 12,500. For next 5 lakh, 20% tax i.e. one lakh. Above 10 lakhs, 30% tax i.e. 60,000. So, I pay 0 + 12500 + 1 lakh + 60000 = 1,72,500. How can I compute through a formula...
  14. H

    Custom VBA Function

    Hello experts, Can you help me with VBA code for custom function to separate abcd1234efg12 into abcd 1234 efg 12 i.e. for every change from letter to numeric and viceversa adding space in between. Thanks.
  15. G

    COVAR() from first principles

    Hi, Can anyone point me in the direction of an COVAR() tutorial/example that shows how the COVAR() function is calculated? I'm NOT looking for examples of how it's used, I'm looking for how it's CALCULATED using lower level functions i.e. SUM(), AVG(), COUNT(), multiplication and addition etc...
  16. T

    "IF" addition question

    Hi Maybe somebody can help. I would like a formula that sums cells T3, Q3, N3 if the text "PP" is or "C" is found in the cell "A3" (I.E 200PP or 155C) but if "S" is found in "A3" then the value 45 is populated. Thanks for any help Stephen
  17. K

    Evaluate a range and return rightmost result (nested if?!)

    Hi there, I currently use an IF formula to evaluate two cells, and return the data in the 1st cell if there is nothing in the 2nd, and the 2nd cell if it is populated; =IF(B1="",(A1),(B1)) Now I would like to do this across an array of cells, i.e. I would like the rightmost cell in a range to...
  18. S

    Enter country code when country name is found

    Hi, I want to have a formula that looks through a range of cells, and if a country is listed ( i.e United States) in a cell, then it will enter the 2 letter code in another cell (i.e US). This would apply for approximately 70 countries.
  19. B

    Extract first digit from cell

    hi all just wondering what formula i can use to extract data from cell A1 "21" only? A1 = 21/02/2018 A2 = 7/2/2018 I have a large list of dates, but I just require the first part i.e. 21 in this case. You will notice, some numbers are two digits long, others are not. pls help?!
  20. B

    Merge Cells in Range

    Looking to merge 2 cells in Range if there is data. i.e. Columns F:G Columns I:J

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top