appears

Hello, I have a macro setup to copy & create 6 of the original tab. After sometime using this macro, an error like message appears. Even if I don't use the macro an try to copy & create a new tab the error message still appears. It takes about 50 "yes" just to create the copied tab. Please see...

I'm trying to count how many times a part of a word appears if a Yes condition appears in an adjacent column. The "2" is how many times "Yes" appears when the word "Task" appears also. Thanks for any help with this. Greg. <tbody> <tbody> Tasks Completed </tbody> <tbody> Description...

I have a table with 3 columns, A= Name, B= City, C=Item. This table may have thousands of rows of data. I then have a second table that list each City and each Item for that city. In column H I need to return the Name that appears most often for that combination of City and Item. I this example...

Hi, Does anyone know how to solve this. I have a lot of cells with free text in and I want excel to list every unique word and how often that word appears

Can some one help me i would like to select a range of cells B27 to J61 If a 0 appears in the cell in column B WITHIN THE RANGE then the entire row would be deleted

Hi What I need to get is the first date when a number appears in column M which is 9-Jan-17 (min date) and the second is the last date a number appears in column M which is 3-Feb-17 (max date) Also it must also fall between the dates that are in columns LL and LM. Any idea how I get arrive...

I'd like to use funkcion IIF in microsoft query ODBC database . I wrote "IIF(resn70='4';0;lqty70*litr35/iscf35/100)" Bat a message appears "SQL0104-Token = is not valid" Please help

Is there a formula that can look at the contents of a cell and return a value based on that number. I think it's more complex than a basic If statement but not really sure. In my example I need to know first if the number 3000 or 6000 appear in the cell. If 3000 appears than a 3 is returned in...

I am running Excel for Mac version 16.11.1 (180319) on macOS High Sierra version 10.13.3. I have written a simple test macro that only does this: Sub RngTest() Dim rng As Range On Error Resume Next Set rng = Application.InputBox(prompt:="Title", Type:=8) End Sub When I run the RngTest...

Hi all, wonder if anyone can help. I have two columns; - E contains dates, in MM-YY format (i.e. 'Feb-19', 'Mar-18') - F contains text ('Same' and 'Changed'). I want to create a formula that counts the number of instances 'Same' or 'Changed' appears in a month. So far I have this: Looking...

I have various text in Col A and values in Col B:N where text "Benchmark" appears in Col A for Example "Benchmark GP per Unit" , "Total GP per Benchmark" etc, I want the Columns from A:N highlighted in Blue in the same row where the text benchmark appears I have tried to set this up but...

Firstly many thanks for taking the time to read. In cell K2 I want to count the number of times the phrase “Grade 7” appears in column M8:M200 but at the same time if this phrase appears in column M I need column R8:R200 populated with the word “Yes” and “No” if it doesn’t. Most grateful for...

Hi All How do a write a formula for the following? I am in cell B2 If cell A2 ends with "CCAP" or A2 appears anywhere in Column ZZ return "Yes" Is this possible? Thank you!

Hi In tables is there anyway of hiding the Filter symbol so it only appears when you click on the header? Thanks

Hi all I was wondering if anyone could help me out with a problem. I have about 1,500 word documents with tables that represent student evaluation. It is a tick box exercise where we have very good, good, needs work. I was wondering if it would be possible to make some VBA code that opens each...

I have a spreadsheet with three columns Col A = Text ( for the purpose of this lets say apples) Col B = Numbers (I just need to count how many times a number appears) Example if the colunm has numbers like 23,15,12, this would count as 3 Col C = Dates ( I need to count how many times a date...

Hi All, I have been trying to use OWC 11 components in Excel 2013 on a 64-bit operating system to create a chart within a userform (combo box) which has the source linked to my worksheet data with absolutely no luck. It appears that Microsoft no longer supports OWC 11 components..does anyone...

Hi Guys, I am looking for a way or VBA to check all data in a selection of cells and put them in to a table with a count of how often each word appears. Example: The Cat ran to the second cat The -1 Cat-2 Ran -1 Etc

So I'm trying to make this SUMIFS show me results from July2016 through November2016 This one works =SUMIFS(COLJUD!D:D,COLJUD!A:A,12,COLJUD!M:M,2016,COLJUD!O:O,$B$5) This one doesn't bring any results and should...