3

This can be done using Power Query. Here is a complete example that creates a table listing each occurrence of pairs of adjacent colors, including duplicates. It would take a few more steps to turn it into a frequency distribution table. Here is my sample of tiles: Select the range of cells containing all the tiles, including extra empty rows and columns is ...


2

Welcome to SuperUser! Several websites I found say to use the Excel Find/Replace window and type ALT+0009 in the Find box. This method doesn't work in Excel 2020 (and I suspect other versions too). What works for me is a one line VBA script that removes all tab characters from the selected cells. Select the cells containing tab characters to remove. ...


2

We can use LOOKUP to return the number of the last row that has a Yes before the current row and compare the numbers. =IF(AND(B2="yes",IFERROR(LOOKUP(2,1/($B$1:B1="Yes"),$A$1:A1),1E+99)<A2),"Yes","No")


2

I think your logic is wrong - you've got if the value is zero, hide the row otherwise (i.e. if the value is not zero), if the row is hidden, show it. Does this do more what you want: Sub HideRows() Dim cell As Range For Each cell In Sheets("Current Assets").Range("Table110[Qty.]") If cell.Value = 0 Then cell....


1

The code can be simplified by using the ShapeRange property of the Selection object that returns all the shapes in the selection. The following example sets the fill foreground color for all the shapes in the selection in window one, assuming that there's at least one shape in the selection. Windows(1).Selection.ShapeRange.Fill.ForeColor.RGB = RGB(255, 0, ...


1

There is no way to change the behavior of Excel without VBA or an add-in. The following add-ins might be able to help: XLTools (commercial) excel-csv-import CSV Import+Export But perhaps it's better to avoid doing the Save As in Excel and do it rather with a PowerShell script. This way you would also be able to save multiple Excel worksheets with one ...


1

(As I put here: https://stackoverflow.com/a/69232281/16941696) Between your question and your comments, I couldn't figure out if you are trying to count hours and minutes, or minutes and seconds. The solution works in either case. I drafted an explanation with both possibilities, just in case. (Unfortunately, I don't have enough rep to post images, so that's ...


1

Do other cells in column C (Such as C12, C13 ) have content? If not, please try the formula =IF(MOD(ROW(),10)=1,INDIRECT("A"&(INT(ROW()/10)-1)*20+11)+INDIRECT("A"&(INT(ROW()/10)-1)*20+21),"") in C11, and then drop down.


1

From the article Insert Excel data in PowerPoint: Link a section of data in Excel to PowerPoint In Excel, open the saved workbook with the data you want to insert and link to. Drag over the area of data you want to link to in PowerPoint, and on the Home tab, click or tap Copy. In PowerPoint, click the slide where you want to paste the copied worksheet ...


1

Like all other queries, it should by default (at least in Excel 365 for Windows 10) get loaded to a new Table when closing the Power Query Editor, like in this image of a query returning a single value: If this is not happening automatically it may be because the query was loaded once already to a worksheet and then the Table or the worksheet was deleted or ...


Only top voted, non community-wiki answers of a minimum length are eligible