e.g

Hello everyone! First of all I have to say is a great forum! found really interesting stuff that helped me with my VBA skills. Secondly, I was wondering if someone could help me with a simple macro that I couldn't find online and is driving me crazy. What I have is a table with different...

Hello. I have a range of cells (e.g. A1:U1), these have numbers in them and I need a formula to check if there is the number 1 in any of the cells, if there is I need to return a value of "Y" and if there isn't a value of "N". Can anyone help?

when sorting a table e.g. A-Z or Z-A, the first cell does not change like the rest. Why is this?

I have the formula below to calculate the unique values in the specified cells. =SUM(IF(FREQUENCY(H5:H3200,H5:H3200)>0,1)) When I apply a filter to a column on the spreadsheet, I'd like it to change the value. E.g. The formula returns 100 when unfiltered. If I filter to show any data where...

Hi All, Need some help with a macro (not done these for a very long time). What I am trying to achieve; - I have a list of 100 rows (e.g. Yellow) which relate to a data set of say 1400 rows. I want to be able to take each item from the List (e.g. Yellow) and then filter the data set with all...

hi all... i have vlookup question how to fix problem; at first, lookup is fine but...for reason..i move/copy my reference tabel e.g name "kki" then copy/move again name of kki (new data), but vlookup show error.. how to fixed it? any help, thanks.. .susanto

Hi there! Been a long time lurker of the forum, but finally forced to ask for help on something I have a column with values e.g. in B1 I have "red", B2 has "Blue", B3 has "Green" etc. In another cell I have a randbetween function e.g. C1 = randbetween(1,N) I want to concatenate from cell...

Hello all I've been given some data from a payroll system. The trouble is, adjustments have been made using negative times e.g. -0:15 for minus 15 minutes. Excel doesn't see these as times (think it must see as text) so any calcs made to these just give errors. Does anyone know how I could...

Hi all, I have a spreadsheet that I seriously need help with automating it PLEASE! Basically I am running a call center and this sheet is for tracking the agents who are on a call, who are available/free and who might be reserved for a upcoming issue e.g. product recall announcement. In ROW...

OK I need some serious help here, my head hurts trying to think of the best way to write this up and keep the code as small as possible, please let me explain... My manager wanted me to update a completely non-functioning spreadsheet in which I did, but now wants me to add another tab in which...

Hello VBA pros, I have a tricky problem (well it is for me) regarding duplicates in a dataset. Regularly I receive manually generated customer lists from our finance/sales or another department including an overview of customers and their revenues in a specific period (customer name in column A...

I have a column of 1000+ numbers, but I want to be able to count the number of rows between each entry containing the value 1, e.g. 1 <-- 15 25 3 5 2 1 <-- 22 14 15 1 <-- How do I count those rows automatically please? Can anyone help?

Hello, Can someone help me understand why my formula isn’tworking? I found online how to returnthe maximum value if two criteria are met yet I can’t figure out why it isn’tworking. The formula is as follows….. MAX(IF('Data'!$A:$A='Result'!B2,IF('Data'!$B:$B='Result'!B3,'Data'!$C:$C)))...

I'm working with a large amount of data in two separate tabs: Tab X: Column A (Product #) contains a list of product numbers (e.g. 700, 701, etc). Column B (Load ID) contains a unique ID for one specific unit of that product (e.g. 12345, 12346, etc). Tab Y: Column A (Product #) contains a...

I have created a budget file with multiple sheets, each sheet has rows by category and columns for each month. The expenses I wish to track can be in one of the following currencies: $, €, ₪, I would like to enter the cost is the currency I have paid at, let's say € so could always know the...

Hello, I have a cell that reads a percent (e.g. A1 = 5%). How can I conditional format the rest of the cells in the column (e.g. A2:A20) to highlight red text if their absolute value is less than A1? Examples of highlighted cells would be 4%, -2%... but not -10%).

Hi. I have a formula that returns a value A (e.g. 2.3E-03) and a different formula that returns value B (e.g. 4.5E-03). I would like the cell to read (2.3E-3 - 4.5E-03). I know that text can be CONCATENATED but this doesn't work for numbers/formulae. Is there away to do this? Thanks Paul

I teach a college class on decision making through spreadsheet modeling and I am currently putting together a lesson on using OFFSET. I'm looking for real-world examples where OFFSET is used. I don't need the specifics (e.g., the formula text, data, etc.) rather simply examples (e.g., I use...

Is it possible to set a table up so that records are sorted into batch numbers automatically... maybe using AutoNumber? E.g. I want the first 100 records to be Batch 1 and then the next 200 records to be Batch 2 and so on...

Hi, Got a problem, I want to use a SUMiF.... though i want to say if cell G1(tab1) = the cell in ranges A1:a350 (tab2) then sum the four cells to the right of A:A (tab2) e.g. B1:e1 (if first row, or what ever row where this is true) if this is false = ""