Hot answers tagged

2

This is just a sample approach. First name the destination sheets as follows: Then run this macro: Sub croupier() Dim N As Long, i As Long, s As String, M As Long Sheets("Sheet1").Select N = Cells(Rows.Count, 1).End(xlUp).Row For i = 2 To N v = Cells(i, 1).Value s = "s" & Len(v) With Sheets(s) M = ...


2

The problem is to create a new sheet, copy the content of an existing sheet, and change references to for cells to a second existing sheet. As Satya Mishra says, that could be done manually by changing 'Day03'! to 'Day04'! after copying to a new sheet, Day05. To make the change automatically when you copy from the previous sheet to a new one, let's restate ...


2

Microsoft has released updates that have caused some downloaded files not to open, most notably HTML with .xls extension. The updates in question are: Windows Update KB3115262 (Excel 2013) Windows Update KB3115130 (Excel 2010) I have found several options that can eliminate the problem. Option 1 Control Panel > Internet Options Security Tab > Trusted ...


1

This formula will convert it to a time. I made it as dynamic as I could: =TIME(IFERROR(MID(A1,SEARCH("h",A1)-MIN(SEARCH("h",A1),3)+1,MIN(SEARCH("h",A1),3)-1),0),IFERROR(MID(A1,SEARCH("m",A1)-MIN(SEARCH("m",A1),3)+1,MIN(SEARCH("m",A1),3)-1),0),IFERROR(MID(A1,SEARCH("s",A1)-MIN(SEARCH("s",A1),3)+1,MIN(SEARCH("s",A1),3)-1),0))


1

In C1: =COUNTIFS(A:A,A1,B:B,FALSE)=0 Then copy down.


1

Select the data from C2 to N13. Create a new conditional formatting rule with a formula. Use this formula =C2<$B2 and apply a format. Note the placement of the dollar signs. As the conditional format is applied across and down, the reference C2 will be adjusted to whatever the current cell is. The comparison will always look at column B, since the $ ...


1

In Excel Options -> Advanced -> Display -> Uncheck "Show all windows in the Taskbar", Click "OK" to close the menu. Then go back and select it again (check the option) and click "OK". Now Alt+Tab should work fine again


1

Microsoft Excel has a plugin called PowerQuery. PowerQuery allows you to import data from your sheet, and run an 'unpivot' operation. This is a very handy tool. It will take you a bit of time to set it up and get it working the first time, but once you do it will be useful for years and let you do this operation very quickly. Here are some details on how ...



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