1. P

    Rota creation

    Hi, I have the data as below which shows personel availability for 5/1/2020, I would like to create a column with concurrent data for personnel that do not have status as "Away" <table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse...
  2. I

    Cell value to be shown as empty until page is being worked on

    Hi, I am not sure if my title explains it correctly but code in cell K33 is shown below. On my worksheet i have the following worksheets Income 1,2 & 3 Expenses 1 through to 8 Here is an emample of my issue. Worksheet Income (1) has a running total shown in cell G32 There is also a running...
  3. C

    Only sum what is shown in table

    I have some very simple data and I have created no measures whatsoever. I am working with 2 tables. One called project table, one called budget table. When we first started we dummied in a few projects and they were never removed from the project or budget table. I filtered them out in my...
  4. S

    Picking Values from a Table

    Hi All I am inputting values into row 2 under certain labels. Each label has a value which corresponds with the values in table A5:B9. The total is then shown in cell B12 (product of a multiplication). I am trying to remove the intermediate step which requires table D12:E16. I assume a...
  5. H

    Extracting out specific text from within a cell

    Hi all, I am trying to extract out various details from a text string. The fields I am trying to extract are as follows: Field 1 = volume information eg. 10 Field 2 = volume measurement eg. Oz or ML Field 3 = perfume type eg. EDT, Eau De Toilette. On this field specifically, several equivalent...
  6. K

    How to reduce betting blokes that can guarantee max 1 incorrect

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> Here I have a question how to reduce betting blokes that can guarantee max 1 incorrect, what I mean this, for example "Euromillions" playing 8 numbers direct we are playing 56 lines it cost 140€ "Formula=COMBIN(8,5)" if out of 8 numbers 5...
  7. danhendo888

    How to change "dates" to clean data!AvjBsEPEq12ngUI4aV0PG-l-4gVM?e=pByejI How do I convert the data in A1:B7 to the output in rows 12 and below (happy to use any method, pivot tables, power query etc) (Purpose is so that I can do YTD calculations using the output)
  8. J

    Next cell in column

    If in, for example, column A you want to paste the data in the next blank row even if it isn't at the end of the data set as shown below - how would this be done via VBA? Apples "Blank" Pears Pears Pears Pears "Blank" Thanks.
  9. L

    GetSaveAsFilename corrupts spreadsheet

    sFName = Application.GetSaveAsFilename(FileFilter:="Excel Files (*.xlsx), *.xlsx, Macro Enabled Workbook" & "(*.xlsm), *xlsm") If sFName <> "False" Then ws.SaveAs sFName, 56 End If With sFName set as a string. I am using MS Office 2016 on win10 if that helps, have not tried...
  10. M

    Extract selected number and move them into another locations

    Hello,</SPAN></SPAN> I got lottery results in the cells D6:J1000, and in the cells C6:C1000 I have numbers from 1 to 50.</SPAN></SPAN> In the area D1:J3 where I want to put the number, which I want to extract, could be any between 1 to 50 and copy past that all rows in the columns M:T the...
  11. S

    IF ISNUMBER SEARCH combination

    I'm using the current formula: =IF(ISNUMBER(SEARCH("Nature",A2)), "Y", "") to show whether a word (shown in cell B1) features in a set of meta tags (shown in cell A2). <tbody> A B C D E 1 Nature Ocean Sun People 2 Nature;Ocean;Outdoors;Water;Sky Y Y 3 People;Sea;Waves;Sun Y Y...
  12. MrDB4Excel

    Check number of digits left of the decimal point

    Hello MrExcel Members, I need to first ascertain how many digits are to the left of the decimal point and then use that data to fill in a multiplier for use in a formula. Following is the data on a worksheet that produces a speedometer graph: Columns "A" & "B" Performance Label Value Poor...
  13. D

    Index function with variable range reference

    Hi Guys I have a sheet with data as shown in columns A:"H below. I also currently have a function as shown = index($d8:h11,match(b3,$b8:4B11,0)match($b2,D7:h7,0). I now want to add in other Type Options B through D. How can I change the array $d8:$h11 so that it is based on whatever is...
  14. V

    Need help in formula.. OR combination

    Current Formula is - =IF(OR(ISBLANK($AJ2)=TRUE,$AJ2="Issued from History"),"Complete", IF(AO2="Process Support","Closed","Closed")) here problem is, when im selecting "process support" in col AO all my answers are not shown as "Closed" because, as per the 1st OR condition if col AJ finds...
  15. R

    Converting data from one tab to another

    I know this is a big "ask", but I need some help. What I need to happen is all the data on the "raw data" sheet needs to be converted to the format on the "converted data" tab. I can of course do this manually but I was looking to do this with a macro and run it from a button on the "raw data"...
  16. M

    Create summary without generating total of combinations by each sum

    Hello, I got a code to By Marcelo Branco, which generate all-possible sets using following layout under this link is superb! The summary below I got generating all combinations with the code and then counting by sum as shown in the Column H:J...
  17. B

    count the number of times a date is shown.

    i have a list of files with dates associated. i'd like to simply count the number of times each date is being shown. for example, 1/2/18 is shown below 10 times. I have this for an entire calendar year. <colgroup><col></colgroup><tbody> 1/2/18 1/2/18 1/2/18 1/2/18 1/2/18 1/2/18...
  18. I

    Advice to locate bug etc regarding date format in excel items

    Morning, My pc date format is set at dd/mm/yyyy In various worksheets i have codes relating to date. Examples 1,Double click on cell in column A i then see 04/02/2019 as opposed to 02/04/2019 2,On a userform a text box is shown as 05/04/2019 i then transfer data from userform to worksheet. The...
  19. S

    combining texts (many many cells) in a smart way

    Hello, I’m having a difficult time creating a function that allows me to combine texts. Suppose I have a data set as shown in “data set” and would like to know if a sentence includes that specific text. I successfully made a set of functions including find/lookup/iferror which provides...
  20. K

    Colour 0 separated by vertical bar in any position

    Using Excel 2000 Hi, I need VBA to get coloured 0 as shown in the example below <colgroup><col></colgroup><tbody> 0 | 0 | 0 | 1 | 1 | 1 | 1 0 | 0 | 1 | 1 | 1 | 0 | 1 0 | 0 | 1 | 1 | 1 | 1 | 0 0 | 0 | 1 | 0 | 1 | 1 | 0 0 | 0 | 1 | 1 | 1 | 1 | 0 0 | 0 | 1 | 1 | 1 | 0 | 1 0 | 0 | 1...

Some videos you may like

This Week's Hot Topics

  • Use Filter function with 2 criteria to return a specific value
    I've spent many hours trying to find out why the basic formula for Filter function with 2 criteria will not return a value other than #CALC. I'm...
  • Loop stopping at row 10
    Below is a code I had a lot of help with from user such as yourself. This code worked well but now is stopping a row 10 and I can't see why! Could...
  • Numerical Order Code for Macro
    I am trying to find a code or fix what i have on the macro that will automatically make the certain column generate in numerical order when I...
  • Calculate time in excel
    I get a text report from our time keeping system that i dump into excel through a data connection and I need to calculate the total hours for a...
  • VBA
    Hello everyone, I need your help please. I just need VBA code to get my reports working. What I want to do is whenever these dropdowns are...
  • Help with formula to sum numbers prior to date
    Hello, I was hoping to get some assistance as I'm having trouble with this. Using my table below as an example, how could I write a formula which...

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