ddd

I am working in Excel 2016 with a SUM(SUMIFS()) formula that I am trying to use with an array as part of the multiple criteria where that array is stored in another cell. Specifically, while I can get this SUM(SUMIFS()) formula to calculate correctly when that array is directly written out as...

Hi, i will insert 2 sets of data to insert in excel. i need formula to auto check which are the data that have error. like data 1 is the correct data, data 2 is the data that might have error. so data 2 have to source for code in data 1 and see if it match or error. each set of data there's a...

hi guys having problem i trying create a code so depend on what day it is the code change prefix is L and the next two number is YY year and the 3 last numbers is DDD (001 - 366) but in number format not words like Sun or Mon so in the case than 366 would be Feb 29 or 206 would be...

Hello everyone, I searched on the forum and couldn't find a post that has a concern similar to mine. I have a column with data (project number) which is the source of a data validation list of multiple cells. Let's say my list of project goes like this: AAA, BBB, CCC, DDD Then in the cells...

Hi all In Row 1 I have the heading names i.e AAA BBB CCC DDD etc What I would like in column P, it looks at that the cell value, and if there is a yes. it lists it in column P So :- -----L---- | -----M---- | -----N---- | -----O---- | -----P---- | ----AAA--- | ---BBB--- | ---CCC--- |...

I can accomplish this task fairly easily with a pivot table or a macro but wanted to see if a formula could be used so it is dynamic. Given a table starting in A1, B1 like this <tbody> Project Level AAA 1 AAA 2 AAA 2 AAA 3 AAA 3 BBB 1 BBB 2 BBB 2 BBB 2...

Cells will contain a number beginning with 2 - can be anywhere in the cell, and number ends when a space appears after it. Can I use a formula just to return the number? eg; ABC 2014999 DDD 2014999 EE FGH A 2014999 A R E In each case the result should be 2014999. Needs to be a formula...

Good afternoon, I have an area of my worksheet containing pie charts that I export to a JPEG at different points in the week - the idea being that I'm taking a "snapshot" of the piecharts at different points in time, to allow me to compare them over a period. The code creates a new worksheet...

DATA FILE <tbody> Grn Name Discount % Class 001 AAA 100 5 002 BBB 100 6 003 CCC 4 004 DDD 100 3 005 EEE 1 </tbody> <tbody> Concession i want to maintain below list just enter 100 in this cell </tbody> <tbody> Sr. No. GRN Name Class 01 001 AAA 5 02 002 BBB 6 03 004...

Hello all. First post/attempts at this VBA. I have had no luck copying and pasting every code I could find... either they copy data from every page, have errors, or require some toolkit. I'm trying to combine all data from two different sheets XPO, and DDD into one sheet CDR. I'm also...

hello all, I need a formula to extract value between last two comma in a string eg. aaa,bb_1,ccc,ddd,v output: ddd

Hello guys, i have table with different projects on each row. i need to create a sheet for each row/project mantaining the title row and naming each new workbook as the project name. Is there a way to do it in vba, im really new to this :/ Example: Original workbook ProjectCode ProjectName...

Hi, I am trying to populate a cell with information based on certain text in the column, and using index match to insert the data in the correct line. Below is a summary of the data. It seems simple but I just can't find anything that works. Excel 2010 <colgroup><col style="width...

Hi, I have an issue. I have some data in Excel which I need to covert. The data is in the format: Mon 12/30/2017 where it needs to be Mon 30/12/2017. I have tried Data>Text To Columns>DMY with no avail - so please do not mention that. Helpful advise welcomed as it's bugging me! Thank you.

Hi, I have two tables: one with all items from a ERP-system (2), and one with manual correction to the items lists product hierachy (1). The manual corrections (1) can hold items which also will be found in the item list table (2). The two tables are joined in an UNION query. My problem is...

I have the table1 below and want to make a table that shows how many friends Ent1 has in common with any other person from Ent1. Eg A (short for AAA) has friends B,C,D,E,F while B has friends A,C,E,F. They have C,E,F in common so the outcome should be AAA BBB 3 Can this be done in acces/SQL? I...

I have two working VBA Macros, each running 58 Data Connections currently as: "iTrackerDataRefresh5Fri" and "iTrackerDataRefresh6Sat" (below is a sample of the data connections) Left as-is it runs 408 data connections which takes time to complete. So, I would like to get smart and 'just' use...

I have one file; Mother.xls Mother.xls has on sheet(6) a list with names of all the employees. I want to create as many copies of Mother.xls as found on the list on sheet(6) each file carrying the name as mentioned on the list. The following code does the trick for me: