searching

Hello, I have written some VBA code but part of the code unlocksand then locks a spreadsheet again once the code has run. The idea behind thisis so that users aren’t able to mess with the raw data / delete entries withoutgoing through the correct procedure. There is however a requirement to...

Hello, Been searching and searching and not quite what I am looking for. Need to search Row(1) for the header "Total" Return the last row used in the Column where the header "Total" was found Thank you

I've been searching and searching but I can't seem to find the syntax for a measure that will allow me to count the number of Mondays within a date range. The date range will be selected through a slicer on the same page. What is the DAX syntax in order to do this? Thanks!

Evening. I have searched the forum but could not find the answer. How do I prevent a formula when searching for a 1 picking up say 12 for example?

I need to fill the "Evaporator Temperature" column with temperatures (selected from the table on the right) that correspond to the System Refrigerant in cell K3. I can accomplish this using the formula =INDEX(D$3:D$23,MATCH(A3,G$3:G$23,1)) But, I am constantly adding new refrigerants to the...

Hi Guys I have several workbooks that have multiple worksheets from 80 to 3000 tabs trying to workout an easy way of searching for the word 'unassigned' on each sheet and changing the tab colour, if found. Is that possible?

I tried to avoid asking this as similar questions have been asked many times, but I can't see the solution I need. Briefly, I need a function [NextNonBlankRow], given a specific row number as a parameter, to return the next non-blank row, searching down. So, if A100 contains a value and A105...

I have a table with dates in format d/mmm and data in second column. I would like to use this in a lookup using dates in any year so I'm searching for a result against d/mmm/yy. Vlookup doesn't work; is there a work around? Geoff

Hello, I need to delete columns that have "'-" in the entire columns. If I filter that it will only shoe "-" in the drop down. I needed to delete all the columns that have those values in cells. I tried searching but could not come up with any.. There are multiple columns that have these...

Hello everyone, this is my first post, I have tried searching the forum but wasn't exactly sure what to search for and couldn't find an answer I have managed to get this formula from searching on the internet, which is working...

Hi All, I'm trying to hide the ribbon tabs except for the "File" ribbon tab. Does anyone know how to do this?? I've did some searching on the topic, but I can't find anything useful for my application. Many thanks in advance! Pinaceous

I'm using this to find cells that contain part of a string; If cell.Value = "*(V)*" Then the relevant part being "(V)".....but now I want to reverse it by searching for cells that do not contain that, I've tried the following but it doesn't work; If cell.Value <> "*(V)*" Then Can anyone...

Hi, Guess it is an easy one, and sorry if it is already here, but couldn´t find it, as i don´t exactly now how to formulate it. I´m searching for a formula to calculate in the following way: <colgroup><col><col><col></colgroup><tbody> <tbody> <tbody> Geography </tbody> <tbody> Upto 500...

Hello All, I am searching for a value with a vlookup that can range from 0-999. Occasionally the value will not exist so I am returning a value of 1. =IFERROR(VLOOKUP("*"&M12&"*",EPN!$Y$14:$Z$40,2,FALSE),1) The cells I am referencing are as below for the 2 fields. However I am getting false...

First, thanks for continuing to be an awesome community! Second, I'm trying to accomplish something by forumla. I'm not familiar with VBA in excel, but if I need to do that, then I'm willing to work my way through it. Here's an image of my current challenge: https://i.imgur.com/MNyjiwb.png...

Hi, I'm having trouble using vlookup which involves "*" as part of the text I am searching for. for example, my query data is: <tbody> A B C D 1 A* 9 A* 2 A 8 3 B 7 4 C 6 5 D 5 </tbody> In D1, I am writing VlookUP(C1,A1:B5,2,0). However, this returns 8, when it should be...

Working from a 2015 macbook pro, excel 2011, a file I use daily suddenly gave me an error I recall having seen some years ago, but can't remember how it was resolved; "The Workbook you opened contains automatic links to information in another workbook". I don't recall copying/pasting to/from...

Hi, I have the following Array formula; =INDEX('Paddock-Plan-Crops'!$V$17:$V$67,MATCH(S$7,'Paddock-Plan-Crops'!$G$17:$G$67,0),MATCH(S$4,'Paddock-Plan-Crops'!$Y$17:$Y$67,0)) I need a modification for this that will sum the values in V17:V67 when duplicate combinations are found in the Match...

I have weekly target sheet in which six columns are occur Like this: <tbody> Week Description PREVIOUS REMAINING TARGET TOTAL TARGET ACHIVED DIFFERENCE 18(30-Apr to 06-May) XYZ 2 5 7 4 3 </tbody> I want to put a formula in pervious remaining colum that automatically search...

Hello, I am trying to get values from a table that looks like this (simplified to a comprehensive and complete example): Anybody have an idea of what function I can use if I have both the size and name of the item (ie L, Hat) to retrieve the price? I am using a "table" (that is not made as...