hi everyone

i am having a problem with duplicate find and matching text, value in excel

using this formula
=INDEX($K$29:$K$62,MATCH(L22,$L$29:$L$62,0))
=LARGE($L$29:$L$62,$J22)
=INDEX($M$29:$M$62,MATCH(K22,$K$29:$K$62,0))

when same number match it match the same name

please review the attachment

I am trying to help my coworker.

He closed an Excel file he's been working on for days. He then opened "My Documents" from his desktop, right-clicked on the file name and renamed the file. And somehow now it is a text-tab delimited file. It had been an "Excel 97-2003 Workbook." He lost all but the active tab. We followed some tips to try to recover, going into the information tab and look for versions, or digging into "manage versions" but there is nothing there.

1. How on earth did his actions lead to the change in file type? :(

Hi There.

I am analysing a sales order book on a week to week basis. The Sales order reference remains the same but order values can change daily based on shipped/cancelled and amended orders. Can anybody suggest the best way to reconcile these differences in excel please?

I am using an excel template and am trying to modify it. I have a sheet "daily schedule" which has a date on it and a to-do section with cells below it. I have a second "task's schedule" sheet that has a column for the date and a column for the task. I am trying to make it so that I can enter in tasks on the task sheet and they will auto fill on the daily sheet. my formula is:

=VLOOKUP(F3,'Task''s Scheduler'!E5:F21,2)

f3 is the date on the daily schedule sheet
e5:f21 is the table on tasks sheet which has the date in column E and tasks in column F.

VBA Need help trying to solve, Select data and records in next column the data below the found data od the selected
I have data in column C starting at row 20. I want to select one of the cells in column C;for data, for Example: 1-20-F. once selected I want to run macro that would search in column C for any data with the letter F, once it finds the data with the letter F it will tell me what is found below the data with the letter F. so if 3-15-H is found below the the data with the letter

Hi All,

I am using the following code to prevent a user from right clicking the tabs in an Excel workbook(windows):

Application.CommandBars("Ply").Enabled = false

But the above code is not working in MAC excel 2011.

Does anyone have idea to achieve this?

This is the file for Josh60's request.

Hello, I have data in column C that is similar to 1-15-A. So I want to search through this unlimited data by placing the letter A one cell above the data in column C and run a search it will look for all the data with the letter A in column C and return the data found below the letter A into column D, going down the column . keep in mind for each A found it will return the next letter below the letter A found, then it will go to the next letter A it finds and returns that letter below that A and so on.

I need a formula to count the number of rows in column B that correlate with the text in column A. So in the below example, I need Column C to return a value of 3.

Column A Column B
Hospital 01
02
03

Hello,

I am working with pivot tables and I'm trying to get a calculated item (a %) from two calculated fields ($) but it is giving me wrong answers. Does anyone know if this works?

This is a fun one.

I'm working on a template to track a forecast spend by project category by week. Also, providing a summary of cost and hours by month. Trying to get it all in one function. My brain wants to do a SUMPRODUCT inside a SUMIF, thus adding the row criteria to key off of "*Cost*" for the monthly summaries.

I was able to summarize weeks and match to months no problem.

In the table below I would like to get a summary table by applying a formula based on the several conditions.They are
IF all the three (Self, Internal and External) are present then the Formula should be(20%Self+10%Internal+30%External)
IF only External and Internal are present then the formula should be (70%external+ 30% internal)
If only External and self are present then the formula should be (70% external+30% Internal)
If only Internal and self are present then the formula should be (30% Internal+70% self)

I have created a combobox in Excel and in need of changing a specific selection to have a back fill of yellow.

For example: my combobox has a list of PTO, OT1, OT2, PHOL, RED
I need to figure out how to have a backfill of yellow when OT1 or OT2 is selected?

Im not sure if this is even possible, I am a little rusty at Excel so any help or insight is much appreciated.

Thanks

Working in Excel2007.

I have a pricelist that I try to sort.

Example:

Art No

6
327
327Q
1017
2245
2245Q
12542

When sorting this normally all articles with the extension "Q" will automaticly be placed last...
After searching the web I found a way to solve this.
http://datapigtechnologies.com/blog/index.php/sorting-numbers-and-text-t...

This present me with another problem.
This will sort the list like this...

1017
12542
2245
2245Q
327
327Q
6
Looks like it only sort by first number and then the second....

What I need is somthing like this.

0006

I have a row of data that contains some blank spaces. I need to find the lower value of the 2 cells to the left that contain data (not blank cells).

eg:

Row 1 is populated thus:

8 blank 6 blank 4 blank 9

so the formula I need would give the answer as 6, because it is the lower of the 2 values closest to the left but not a blank cell.

Is this possible ?

Thank you.

Hi,

We've been scratching our heads regarding this weird problem:

We are trying to import data into excel that requires the UTF8 character set. When we load the file in excel the drop down list only shows one character set (ANSI). This happens on one laptop so I know it's something to do with the laptops setup.

We've tried:
-Loading extra character sets into Windows 8.1 (The OS on the laptop)
-Searching Google
-Re-installing Office from scratch (de-installing first of course)

Goals:To display C,D,E and the rest of the column at the at row if any of it is entered at the textbox. Even though there are 2 same variables, for example the date, both rows and columns information can be displayed at a textbox,label or msgbox. I really need help with this as its a proj assignement.

I have excel 2013 and I just recently installed the solver add in. I can now see it in my data tab on the excel sheet that I'm working on. I have two sheets uploaded at the same time. They are actually sheets with pre-loaded data. when I click on box labeled "send to multi-lineup optimizer" i get a "run time error 9" subscript out of range. I need help please thanks.

Help needed to fix spreadsheet.

HI team I am working on a sales excel workbook that will help with trends, forcasting, comissions, daily targets etc. Stumbling through and I need some assistance with the below scenario and how to enter:

I have attached the workbook I have made from scratch.

Here is the formula I need help with:

if sales $0-$20,000 no commission,
if sales $20,000-$45,000 7.5% commission on all sales.
if sales >$45,000 - Budget 10% commission on all sales.
if sales >$45,000 + > combined budget 15% commission on all sales.

Hello,

I have the code working successfully, yet I am needing to have a Userform that populates the correct Agents data.

[code]=INDEX(OFFSET(EmployeeData!$AB$27,MATCH($M$4,EmployeeData!$AB$27:$AB$500,0),0,12,2),MATCH($AI$2,$W$4:$AH$4,0),2)[/code]

The Code above gets the data from the EmployeeData sheet and shows it in the ReviewAgents sheet. Need the Userform to populate the data in the Agents section by month in the employeedata sheet.

Here is a sample file, Any help or suggestions is appreciated.

Best Regards,

John

I have a problem with my Fill Handle. My Database is in a Vertical position but my Table is in a Horizontal position. So if i want to use the Fill Handle it wont work because it only uses the numbers in horizontal positions. Signs with $ don't work because i can only lock the column. Can somebody please help me with this.

I want to create a formula that would calculate like this...
unfortunately, i am unable to use the formula using IF as the data is too long. Any idea how i can do so?

20% 5
19% 4.75
18% 4.50
17% 4.25
16% 4.00
15% 3.75
14% 3.50
13% 3.25
12% 3.00
11% 2.75
10% 2.50
9% 2.25
8% 2.00
7% 1.75
6% 1.50
5% 1.25
4% 1.00
3% 0.75
2% 0.50
1% 0.25
0% 0.00

Hi, I know what I want to do, but I'm not sure which function I'm supposed to use, if any at all.

I'm making a grade sheet for my students for a standardized test. On this test, getting 35 answers correct (GRADE) is a score of 120 (SCORE). Getting 34 correct is 117, getting 33 is 113 and so on and so forth. I want to be able to input my students' GRADEs into a cell and have it return the corresponding scaled SCORE. This can be in the same cell or in an adjacent cell. How do I do this? Thank you in advance for your help!

Hi,

I am trying to find the highest 8 hour period of sales in a week long period. I have sales $ 24 hours/day for 7 days.

What is the best way to find the highest 8 hour period of sales?

Data follows this format (for 24 hours, 7 days)

Time 1/1/15 1/2/15 1/3/15
1:20 2 4 4 6 6
1:30 7 7 7 5 5
1:40 3 6 6 4 4
1:50 1 5 5 3 3
2:00 7 4 4 2 2
2:10 3 3 3 1 1
2:20 8 2 2 0 0
2:30 4 1 1 0 0
2:40 2 0 0 0 0
2:50 8 0 0 0 0
3:00 0 3 6 7 7

Hello. There is macro which saves Web to PDF. After IE and Excel upgrade macro doesn't work correctly and offer to save Web page in html. Please advise how can resolve this problem. Thanks in advance! :)

=INDEX(ExpenseTable!$E$2:$E$81,MATCH([@Group],ExpenseTable!$F$2:ExpenseTable!$F$81,0))

Hi Everyone - New member and fairly non-expert Excel user.

I have somehow managed to create the above formula, and it works to some extent. However, as I have discovered by reading various websites on Google, the problem with this formula is that it only finds one instance, and then it repeats that instance without finding others. So, I essentially have a long table, and the result of this formula is repeated the same each time, rather than tallying up all of the related totals.

As known, when criteria cell is EMPTY excel IGNOREs that Criteria.

BUT, the problem is;
- If criteria cell is really BLANK, excel really (totally) ignores that criteria
- If criteria cell is BLANK with FORMULA (as ="" ), then excel ignores that criteria again, BUT this time NOT COUNTING "the ROWS with blank cells" in database table.
(As seen clearly at attached file)

Problem is a simple point, but solution is not found yet:
According to Excel's reading, the Difference Between "Blank Cell" & "Null Text" is causing this problem in Criteria Cell.

I have 6 different rows that represent 6 different projects.

I have 3 different graphs 'Alignment to Strategy', 'Speed to Market vs. Risk' and 'Innovation'. I'm using 3D bubble graphs to represent the data values from the said project rows vs. different x units. What I would like is to have the different projects represented on the graphs as the same color.

Example:
Speed to Market Graph

Cell A2 is Project FTB (Project Name)
Cell B2 is a value of 12813 (Speed to Market vs. Risk)
Cell C2 is a value of 4.7 (Alignment to Strategy)
Cell D2 is a value of 20.0 (Innovation)

Hello,

I was wondering if someone had a simple solution to my problem. I am looking to get numbers that I adjust or edit to automatically turn a color after I leave that cell.

For instance, for my work I write purchase orders and sometimes I make edits to these long purchase orders. I send the original order in all black text to the vendors but when I make edits I highlight the changes in red text. Rather than me clicking the red font button after every edit I complete, is there a more efficient way to do this process?

Thanks in advance!