alter

Using the formula=MOD(ROW(),2)=1 to have every other row have color to make it easier to use a large spreadsheet I have. When I change the column filters the rows are no longer colored every other row obviously. Can I alter the formula at all to have it reset when filters are added? somehow use...

Hello Friends, I am using this formula to count unique values in a range =SUM(IF(FREQUENCY(IF(LEN(orders_ref)>0,MATCH(orders_ref,orders_ref,0),""),IF(LEN(orders_ref)>0,MATCH(orders_ref,orders_ref,0),""))>0,1)) I want this formula to count only visible cells.... If anyone can provide a...

Hello All. I very kindly maanaged to get a 'Clear Cells' sub from the board. (Thank you Fluff!) :-) The sub code is below; Sub ResetCells() With Selection .Font.Name = "Ariel" .Interior.Color = xlNone .Font.Color = vbBlack .ClearContents End With End Sub Is there...

The Code Below Saves the File as "2019 Rate Volume - 2018-08-21.xlsx" I would like to have it saved like this "2019 Rate Volume - 2019-08-21.xlsx" How is the best way for me to go about this? Thank you in advance. 'Date Save Update Definitions MonthPath = Format(Month(Date), "00") & "...

Hi, I am looking at a spreadsheet provided by a colleague. It appears to have restricted the column's viewable. So I can only scroll over to column AH, and then it just ends. This must be a setting, it is not like the extra columns are hidden. Does anyone know how to alter these settings...

Hi all, Just to start, I'm not an Excel expert and just have basic skills. The situation is that i have an existing Excel sheet that was created a couple of years ago by another person who is no longer available. At a basic level, the section i want to alter has a box in which you input a...

I have a worksheet with over 3 months worth of data entry. My coworker claims she can't understand the layout. She wants me to change it from example 1 to example 2. Is there any easy way to do this without re-entering 3 months worth of work? Example 1 <tbody> WK# Date Accnt Name 1 7/9/15...

Excel/VBA gurus: I have a very long column of strings that looks like this: . A 1 one num 1.23 JUL27/09 2 three num 2.34 NOV8/10 3 five num 2.59 DEC10/10 4 seven num 3.90 JAN1/11 I want to alter the first word (one, three, five..etc), based on the following reference array...