test

Can someone help with code that will look down range B1:B50 and when a minus sum is found, delete that cell and the adjacent value in column A, then remove those blank cells. Not remove entire row - just blank cells in columns A:B example Test 1 200 Test 2 -300 Test 3 1345...

I have an Excel workbook that has a sheet that has a list of 500 stores numbered Store number 1, store number 7 store number 11, etc.. - these are my test stores. The store number is in column A. I'm calling this sheet "500 Test Stores". The sheet doesn't contain duplicate store numbers, it is...

Hi all, I'm very new to excel queries and was wondering if i'd better off using VBA for what I'm trying to achieve? Also are queries the same as power query? Is power query an add in? (Like I say I'm very new) Essentially, I'm trying to combine worksheets into one Master workbook and then...

Hello all, I am trying to call a function from an xlam file I created. I would like to keep all the code in 1 place so I do not have duplicate code in a workbook as well. Ideally this should work for anyone that has the add in [not just my computer]. The function I want to store is 'Excel...

Hello, I have 4 different lab tests I run every week for 4 weeks, then it resets. So lab test 1 on week 1, lab test 2 on week 2...then week 5 back to lab test 1. If I know that the week of Jan 7 2019 lab test 3 was run, how do I create a formula that allows me to enter a date and it reports what...

Hello How would I create a formula that updates automatically when I update/change the selections in my spreadsheet filters? I have a large spreadsheet with columns for school names, teacher names, class names, subjects, students and columns for test scores. I need to count the number of test...

Hi Excelakos, I've started a new thread so we don't continue to hijack the previous thread with a different problem. Here is the same solution across sheets, just change the names & ranges to what you need and test if it suits; Book1ABCD1Service CodeRate Valid From (dd/mm/yy)Rate Valid to...

Hi, i am ccocatenating 2 columns that are I and J, and i want the test in column I to be bold. how can i do it?

Hi, I'm seeking assistance with the following: I have five cells, each with a single whole number ranging from 2 through 50. I'd like know if any of the five cells can be divided "equally" by one of the other four cells (no remainder). If this tests true, then a 'test column would be set to...

Hi, I know how to test a defined variable, but for the life of me I can't figure out how to test whether a user follows through the SaveAs prompt that I'm calling below: #If Mac Then MsgBox "Please save the file somewhere it can easily be found, such as your desktop. You must...

Hello, I want if it contains a predefined value in a cell, to delete that row but not before to add the value that it has to the upper one, example below: A B C 1 apples 30 2 orange 105 3 test 5 4 carrot 40 5 test 10...

Hello, Is anyone aware of how I can call a mailto: hyperlink in a cell to activate using VBA? I've tried all of the following. Sub Test() Worksheets("Sheet1").Range("B7").Select End Sub and Sub Test() Dim CurrentPath As String CurrentPath = Application.ActiveWorkbook.FullName...

Is the null (0 length) string ("") the same as Empty or not? The Immediate window seems confused or ambivalent: ?"" = empty True ?isempty("") False xblank = "" ?xblank = empty True ?isempty(xblank) False It appears that Null is different than anything else: ?null=empty Null ?null=""...

I have one of these on my worksheet but there is no code anywhere that would have AddItem'd it. I must have done it but I can't remember how. Tried adding another one as a test but I can't see where items would be added to it. What as I missing ?

Hello the below is a sum formula and adds number less the 0 and if other column matches the word "TEST" =SUM(SUMIFS(E2:E308,E2:E308,"<0",F2:F308,{"TEST"})) How do I make the formula still work if the other cell contains the word TEST along with other words? Does not have to be only the word TEST

In the past I've gone to financial interviews where my know-how of excel was tested. They asked about SUMIFS, IF statements, vlookup, hlookup. I know the basics behind these. I thought I knew enough of excel. But the test results differ. I'm an intermediate. I want to know how to prepare for...

What formula could i use to to find names in a of information? Would using a index and match make more sense than a Vlookup or something Else? I'm trying to say if the information in column A appears in Column C, Appear in Column B <tbody> Column A Column B Column C <tbody>...

I have a very large spreadsheet that has several rows of data that are duplicates of other rows, except for data in one cell. For example, A B C D E <colgroup><col width="152"><col width="80"><col...

Hi folks, With the intention of economizing some coding, I attempted the following Select Case structure (aberration in Red): Public Sub Dummy() Dim Test as Long Select Case Test Case Is = 44 {Code} Case Is = 45 {Code}...

Hi, how do I create a If Then Statement to compare ANY of the values in let's say cell B1-B200 to A1. See typically the If then Statement to compare a single value would be = if (B1>A1, "STOP", ""), but now we need to test B2 to 1, B3 to A1, B4 to A1.... and have a message stop if ANY of the...