shown

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" Book1WX22Sunday Away05/01/202023AAway24B25C26DAway27E28F29G30HAway31I32J33KAway34L35M36NTable Build Concurrent data...

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

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

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

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

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

https://1drv.ms/x/s!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)

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.

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

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

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

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

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

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

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

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

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

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

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

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