step

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> Here the below is my example I need Formula is preferable or an alternative VBA for conditional formatting to highlight each next step pattern in the complete row as per "specific pattern shown in the cells C4, D4 & E4 which is changeable as...

Hi, Forum newbie here, this site has helped me many times as I've always found that my query has been asked and answered before but not this time hence my first time post. So hello! and I hope someone can help on a puzzle that is beyond my Excel knowledge, hopefully I can explain it correctly...

I have a spreadsheet with Positions down the side and Steps across the top and the rates in the columns. I need a formula that will pull the rate for the first available step into one column. So for receptionist, it would pull the Step 1 rate, for Technician it would pull the Step 3 rate and...

Hello Guys I need help to copy information from one column to another using an appropriate excel formula. I want to do away using cut and paste methods because am dealing with lots of data hence want to save time. My excel skills are basic but catch up quickly. So a step by step guide will do...

I could use some help with this formula. First time using an IFERROR formula so not sure what I'm doing wrong. I keep getting a "too few arguments error". Any help would be appreciated. =IFERROR(INDEX('[TICKET STEP LONG.xlsx]RAW_COMPLETIONS'!$B:$B,MATCH(G2,'[TICKET STEP...

Hello, I need help with my project, I am confused should i use Excel Formula or VBA to complete this project. I have requirement that if the column with all details say "No" in any of the column cell need to copy the "question" to another sheet. So For 1st step need to check column F if any...

Hello, I have a userform and looking for a way to add a popup calendar to insert a date in a textbox, I searched google and found the way below, I followed it step by step, but it didn't work, https://chandoo.org/wp/pop-up-calendar-excel-vba/ Do you have any way to activate it? I have...

Hi, I found this neat VBA code to protect / unprotect all worksheets without having to do each one manually. See below. The only problem is, it only allows; - Select Locked Cells - Select Unlocked Cells Whereas I want another 2 options to be included as well; - Format columns - Format rows Does...

Hi need some help, i try to search around the forum but seen not able to find one i want. Step 1 (list filename of Folder & SubFolder), there will be a POP-UP and ask user to select the path Step 2 (rename filename base on col C) & Status update on Col D Isit gd ideal to display ext...

Hi all, If possible I need a VBA that does the following:- Saves the current workbook then, Save as/copies the workbook into txt format. I have the following code but, it appears to be bypassing the first step (just saving the sheet) before moving onto the second step...

I have a workbook which contains the Function IsEmailValid(strEmail) It does its job perfectly well, but when I step though other code modules and change the worksheets in any way, this function suddenly gets called and I have to step through it to resume where the code suddenly jumped out. I...

Greetings, I would like to be able to step through lines of code in the Visual Basic Editor, but am unable to do so with F8. My 'F' buttons are set to monitor brightness. How do I locate the shortcut key to step through lines of code, and either reset it or just view current shortcut keys...

I just bought the latest version of Excel and I use to be able to step through my macros with F8. It no longer works. Also My control buttons don't work. Has it changed?

I have a fairly simple model that has 10 steps and the time & cost of each step. <colgroup><col style="text-align: center;"><col style="text-align: center;"><col span="3" style="text-align: center;"><col style="text-align: center;"></colgroup><tbody> ID Activity ActivityTime Activity Cost...

What is the must efficient formula to create a TRUE/FALSE result for the following without having to write a huge step by step OR formula - or is that my only choice? IF AQ3=AD3, TRUE or IF AQ3=AE3, TRUE or IF AQ3=AF3, TRUE or IF AQ3=AG3, TRUE or IF AS3=AD3, TRUE or IF AS3=AE3, TRUE or IF...

Hello, I am looking for a couple formulas to solve this issue, but one would be even better. I took a two formula approach in the example below. 1st formula will find rows in column A that begin with a defined letter, such as "M" in the example below, and then return a value in a different...

Hello Friends, please help me, How do I calculate the same result, which is next? for example: result=What formula to write to count the result 1= How many games have won a step by step? 2 = How many games have you lost in step by step? 3 = How many games have played a draw step? <tbody>...

I can seem to wrap my head around on how to put a formula together. Could someone provide assistance with a formula. Thank you kindly. "How do I annualized a return on an investment that has cash added or subtracted during the year?" (1) Total the beginning Account Balance and any...

I want to distribute points among the riders according to the ranking of the stage. The lay-out: Ranking of the stage in column A:E My rider selection in column G:J Points to display in column L:Q (Here I want to display the results, the points) When a team in column J is present in column D...

Hi All, I'm experiencing a problem where power query slowed down after I merged two tables. Since the merge, each time I do a step, it appears its recalculating or refreshing something in the back ground. the refresh stops when it reaches 120MB which takes about 5 to 10 minutes. So basically...