col

Hello: I have the following data. I want col A to equal the value of the first cell to its right, but retain it in a formula. For example the successful result in A2 would be "=B2" not "1". The following code gets the value in col A but it's a value, not a formula. Thank you! <tbody> A B C D...

Hi: I have data in col A and B. I'd like to build a macro that, if it finds the term "trigger" in col A, it copies the data in col B to col C (all in the same row). But, if it doesn't find the term "trigger" in col A, it copies the prior successful data to col C. Here's what I have so far ...

Excel 2007 Col B and Col C contain numbers in numericals. I am calculating C24*75%, minus B7, minus B11, minus B15. For example C24=10000, B7=246, B11=543 and B15=688, then C24*75%= 7500-246-543-688 = Answer 6023. Kindly advise me formula. Thanks,

Hi need some help, i try to search around the forum but seen not able to find one i want. Step 1 (list filename of Folder & SubFolder), there will be a POP-UP and ask user to select the path Step 2 (rename filename base on col C) & Status update on Col D Isit gd ideal to display ext...

Hello all, A1 on sheet Log, will be a Month and Year only (Mar 2019) A2 Should be first day of the month selected in A1, Col A will have all the next dates of the month until the last 31st But what I would like is if I select Feb 2019 in A1 all the col A fill up until the 28th Feb (Cell A29)...

Hi everybody, I haven't been able to figure this one out on my own. I'll try to keep this as simple as possible. I need to search the rows of data for duplicate entries of Last Name (Col A), First Name (Col B) and Location (Col AB). I have 3 radio buttons used to select the sorting of the...

Hi I have a spreadsheet that comes every month with a lot of payroll data on it. I need to update a master sheet that holds summary details each month. My problem is that the data in the columns from the payroll spreadsheet can be different each month eg month 1 col D may have OT1 but next...

Hi, Column J shows the leasing period in months, when start date is entered (col. K), then the end date (col. L) is automatically calculated by this formula: =IF(AND(J4<>"";K4<>"");K4+DATE(0;J4;0);"") Please see URL for screenshow below. On the red marked rows, it does not add all months (see...

I have a number of dates in col A. If I copy the cell and paste value I get a number like 43566, which I'd expect. But if I write a formula in col B such as =datevalue(A1) I get a #VALUE ! error. Can anyone advise why this might be happening and if I can fix it?

Hello All, I have a report that has data in a Column based format (Left to right) that I need to convert into a linear format (up and down) and not sure that fastest way to accomplish this. My data has column detail from Columns A:F, in in Columns G:AP there are ID's that I need to grab and...

Data set Col A A A C Col B J K J I want a function that will do this:=COUNTIF(A1:B3,AND(A1:A3="A",B1:B3="J")) and in the data set above, the COUNTIF would return 1. I know that I could add a "Helper" column in Col C that has =AND(A1="A",B1="J") and put a =COUNTIF(C1:C3,TRUE") but I don't want...

Del Duplicate Row if Col A, B, C matched I had thousand row, so possible to use macro?

https://chandoo.org/forum/threads/data-validation-for-2-columns.42439/HI, Looking for solution to one problem. Problem is -we have number of countries in different regions like Europe,Africa etc. I have data validation in col A and Col B...when I choose any region in col A it is also showing...

Hi, Asked for help regarding below in a different thread but since it evolved to be very disconnected from the subject/title I am reposting it as a separate thread: Please see picture, https://imgur.com/28MVScU I want the formula to do the following: Divide the costs in col B with the number...

Here is my data: Col A Col B Col D Col E <tbody> 01/01/2010 a 31/12/2009 a 02/01/2010 b 01/01/2010 b 03/01/2010 c 02/01/2010 c 04/01/2010 d 03/01/2010 d </tbody> In cell G1, I type: =MATCH(1,(B1=E1:E4)*(A1<=WORKDAY(D1:D4,3)),0)...

Hi, i really need some help. I had many folder to move :) I want to move all inside files inside folder a to folder b *No overwrite of file with same filename as whole *delete empty folder <tbody> From Folder (Col A) Move to Folder (Col B) \\abc\folder1\ \\abc\Main1\ \\abc\folder2\...

Currently I have a column of dates (A) and a column of numerical values (B). <tbody> A B 1/1/19 1/2/19 8 1/3/19 3 1/4/19 1/5/19 7 </tbody> The dates are listed in ascending order in col A. The values are listed in col B but not every date has a value. In a separate column (E) I...

Hi All, Thanks in advance, i have a data <tbody> Coloumn 1 Coloumn 2 2305 2054 0654 </tbody> now i want to split, but when we split the data, "0" is not coming <tbody> Col 1 Col 2 Col 3 Col 4 Col 5 2305 2 3 5 2054 2 5 4 0654 6 5 4 </tbody> pls provide the VBA...

concatenate if cells (col) is not blank anyone can help me :) <tbody> H K L (Result) ABC no result due to K is blank. Formula here ABC D ABCD </tbody>

Need some help, How to Clear the entire col expect A1 ? The column contain data & empy so i want to clear the whole column except a1 btw, i had column A column C column D column E column I column J column K need to clear