aaa

hi, I'm having difficulty creating a formula using INDIRECT to cross reference a series of relevant rows (columnA) and searching for specific criteria found in another sheet, and once found outputting each result. eg: using a csv for the data Sheet 1 will have the data...

I'm trying to write a multiple if(or statement with three data points. IF(OR(AA11046="AAA",OR(AA11046="AAB",OR(AC11046="YES"))),"YES","NO") Brings back "no" no matter what. I'm trying to say if the points are aaa and aab and yes then give me yes. all others should be no. Any help is...

hi all, This is the SQL data I imported into power pivot: <tbody> ProfitCenter_Name Account_Group Project_Group Fiscal_Year Q_FY Edition Edition_Type Revenue A AA AAA 2018 Q4/18 Actual Internal 5 A BB BBB 2019 Q1/19 Actual Internal 9 B CC CCC 2018 Q3/19 Other External 10 A AA AAA...

Hi Excel gurus I have a long list of company names (list a) and a shorter list of company names (list b), i'd like to search for each of the companies in list b within list a BUT need to use fuzzy search, i.e. If list b contains "AAA BBB CCC" - need to know if list a contains either "AAA"...

I've hunted for some help in the forum, but I cannot find what I'm looking for or get it to work in Excel 2013. I think some of the threads on Index and Match are the way I should go, but I cannot get it to work. Basically I have a value on sheet1, and I want to find the first occurrence of it...

Howdy, If anyone can help me ... In column A there are item names, in column B are numbers. In columns I, K, M and O are numbers and in the columns adjacent to the columns mentioned, ie J, L, N and P can be numbers and text. I wrote in column C the desired results. Example. I'm looking for the...

I am sorting a list of client names. One of the companies' names starts with AAA. For some reason, when I sort the range by alphabet, this name ends up at the end of the list (under names starting with Z). Why is this? Is there any way to fix it? Note, it is not an option to change the name to...

Hopefully someone can help! I have the following formula, but I need to include it to look at the value in column BL for a specific value of "AAA" =INDEX(Sheet1!$AN$2:$AN$33461,MATCH($A4,IF(Sheet1!$BJ$2:$BJ$33461=L$1,Sheet1!$B$2:$B$33461),0))/100

Hi I need an index match to get all the b1:e1 which are greater than 0 Anyone can help ? <tbody> a b c d e f g h i k 1 aaa bbb ccc ddd 2 0 1 0 1 bbb ddd 3 1 2 3 0 aaa bbb ccc 4 2 0 0 0 aaa 5 6 </tbody>

Hello! I'm somewhat new to Excel, so I pre-apologize for any ignorance and appreciate your time. I am working on a spreadsheet for a small department where I work to track our time at the company's various locations. I have a setup with a couple of sheets, the first with the information...

Hello! I'm somewhat new to Excel, so I pre-apologize for any ignorance and appreciate your time. I am working on a spreadsheet for a small department where I work to track our time at the company's various locations. I have a setup with a couple of sheets, the first with the information...

Hello everyone. I've wrote the following VBA code that captures a range of cells from an excel file and send it via email adding a brief description as introduction. I'd like the uppercase AAA, BBB and CCC to be in bold. How can I do that? Sub Send_Range() ' Select the range of cells on...

Hi all, hoping this is a nice easy one. I have a list of contractors in column U (they appear more than once). I have an invoice value for each transaction, set against these contractors in column X. Does anyone know a formula to COUNT up the total value per contractor? i.e. the value for AAA...

I saw a great video yesterday that allows me to make a list within PQ from ExcellsFun YouTube that can make a list from A to Z. I then Tried to make a List going from either AA to ZZ or AAA to ZZZ. I created a Blank Query that simply had ={"AAA".."BBB"} however it didn't like that. Is there a...

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--- |...

Hi Forum Hope all is well. I need some help with a formula. I have two worksheets Data and Results. In the results table I have a heat map and the formula matches and counts two variables from data. Example e.g. Column A Column C AAA 2020 AAA 2020 AAA...

I have a report with a SQL query which brings up some results with one "user" column which is literally just "user01, user02, user03" etc. among other names. I'd like to add a "user_actual" sheet to do a vlookup against, so it'd just be 2 columns with "user, actual name" and allow the report...

Hello everybody. I've a situation like this: I've to find the string in cell A2 ("C57") in column F (the recurrences could be 0 or 1), and then copy the values INFO 1, INFO 2 and INFO 3. In this case: B2 EEE C2 CCC D2 AAA https://imgur.com/a/IW3vL I've tried with INSTRING and VLOOKUP, but...

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...

Dear All, I have one user form details of which are getting capture in excel sheet – Sheet1(Data). Currently with the help of userform code I am just able to put the details like below – i.e. only till its opening stage. <tbody> A B C D E F G 1 Date Region Issue Type...