requires

this is a very special settings I need for this task ... but it requires many setups i only have 1 Userform for a Main Matchlist but i know there will Be 127 Match's in my Knock Out system "CUPGAME" The Main Matchlist is Take action from the combobox'1 to set Players in to the Game and Referee...

Hello In Column Meter Type I have the following formula =IF(AA2="LARGE",AND(AC2={"BASIC","MRIM"}),"Meter Requires Upgrade") What I am trying to say is that if Column Classification contains the value "LARGE" AND column Meter Installation Code Contains the value "BASIC" OR "MRIM" then mark...

Hello I want to numberformat with many columns at one go Can i ws.Columns(3, 5, 9, 11, 23, 27).NumberFormat = Trim(Replace(Format(String(Len(Int(Cell.value)) - 1, "#"), " @@\\,@@\\,@@\\,@@\\,@@\\,@@\\,@@0"), " \,", "")) & ".00" Also Cell.value in red requires proper syntax Will the above...

Hi All- I am attempting to return a specific value if the text color is red. I have the following macro, which is functioning, but only for a single cell: Function TT(r As range) As String If r.Font.Color = RGB(255, 0, 0) Then TT = "Complete- Requires IL Address Update"...

Is there a formula that creates a text string as shown below from the following inputs: Period Start 4 Period End 6 Factor 0.5 Text string 4|0.5;5|0.5;6|0.5 The text string is in a format that a software program requires for an upload file. Any help appreciated. Thanks

Hi team, I've gotten into the habit of creating code like so, which requires the .select behaviour. Which is all well and good but I now want to not have to make tabs visible due to the limitations of my code. How would you suggest I get the same output, without the use of .select which...

Hi, I have the below data which shows the comlaince rates and grade bandings for 26 different audits carried out. the date range over which each audit was carried out has been given a weighted score. I have a hypothesis that the lighter the weighting the more likey you are to get a 'good'...

Hi All, So I'm trying to return a value of "Elite", "Athletic", "Average" or "Requires Conditioning" in the formula cell based on single leg jump height in cm (enetered into E69 and F69 compared to a percentage of leg length ($H$4 in the formula). The formula will take the lowest jump height of...

I have an excel sheet that I am attempting to apply restrictions to and also requires a drop down list. End Goal: I want to make it to where a user has to select a cell in COLUMN A, choose a value from a drop down list (drawn from COLUMN D), before inputting any data in the corresponding cell...