Move text

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Worksheet
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - IF Function formula I posted this in the general questions but it's better suited for here: Hi I need some help figuring out if it is possible to create a formula. I'm trying to link information from different pages in a spreadsheet that contain id's for people and prices they are paying for some items my church is selling. We have a main worksheet that lists their names and the ids and then we have another worksheet that lists all the items they can buy with it's price. Is it possible to create a formula in the name page that says "If you find id #1 in column A, then sum the prices from column D". The ids will be spread out throughout column A so we need a formula to locate each instance of the id and then grab the price listed each time in column D and sum those prices up. Is this possible and if yes can someone tell me how to do it. Thanks Tag: Move text Tag: 506304
  - 2
    - How do I ingnore non-numeric cells in Analysis toolpak? When using the Correlation Function in the analysis toolpak, I get an error message if my dataset contains non-numeric fields. Is there a way to get Excel to ignore fields that are non-numeric? Tag: Move text Tag: 506294
  - 3
    - Excel - Formulae across several sheets I have a period (4 week) sales goal. As I complete week 1, I need to know how much remains of my sales goal. I created a spreadsheet which tracks sales for many accounts for one week (or sheet) at a time. On sheet 2 I need to subtract the total sales from sheet 1 and show remaining sales goal as of week (sheet) 2. Basically, on week (sheet) 4 I need to know what remains for that week. How do I transfer data from sheet 1 to sheet 2; then cumulatively to sheet 3, and finally, cumulatively to sheet 4. Any help will be sincerely appreciated! HELP!! Tag: Move text Tag: 506292
  - 4
    - Formula Funtions Hi, I am working in excell 2000 and I would like to write a formula that would divide a numer in one cell and times the decimal portion of the answer by the same amount I was divding it by. Example cell A1 would countain the amount I entered 5000 I would like cell B1 to divide the amount in A1 by 560 and then times the reaining amount that would be in decilmal by 560. Don't know if this is possible or not? if you divide 5000 by 560 you get 8.928 if you set your decimal point to 3 I would like to take the decimal part and times that by 560 which is 519.680 I would like to round up the 519.680 to the next whole if the first number on the right of the decimal is 5 or higher. then my answer in cell B1 would be 8.520 Thanks if anyone can help with this. Hope my question makes sense. Tag: Move text Tag: 506283
  - 5
    - Cash Flow Solution: Eagle Capital Corp Cash Flow Solution: Eagle Capital Corp Same day cash flow to your company. Instant cash that can be used to meet payroll, or simply provide working capital to run your business. http://www.healthhuman.com.cn/Cash-Flow.htm Tag: Move text Tag: 506276
  - 6
    - Muti-page workbook highlight specific dates that occur throughout I'm working on a muti-page workbook and want to highlight specific dates that may occur throughout the workbook. I want to be able to type in the date and it automatically highlight that date if it occurs anywhere in the entire workbook. Tag: Move text Tag: 506275
  - 7
    - multiple if statements I have 3 date columns (Columns A, B, C) and I need one formula (Column D) to return the following all inclusive result. I can get some of it to work but no all. HELP! And thanks. IF B1>=A1 =NETWORKDAYS IF C1>=A1 =NA IF B1<A1 =ERROR IF C1 OR B1 is blank =0 Tag: Move text Tag: 506268
  - 8
    - custom views troubleshoot i have the error message that view settings could npt be apllied when in excel. the sheet contains data and I want to view certain sections under different and multiple views. Tag: Move text Tag: 506267
  - 9
    - Function to calculate total hours worked in one week. I have a spreadsheet that has rows of employees. The header row lists Name, Mon, Tues, etc, through Friday, with TOTAL HOURS WORKED at the end. Each row, under day of week listed the employee's work hours (ex: Under Monday I have 7:36 - they worked 7hrs and 36 minutes). How do I calculate the TOTAL HOURS WORKED for the week? I assume there is a formula, but I can't figure it out for hours:minutes worked per week. Thanks so much for any assistance! Tag: Move text Tag: 506256
  - 10
    - when I type 1 it is displayed as 0.01 when I type 1 it is displayed as 0.01 Tag: Move text Tag: 506255
  - 11
    - Tabbing to select fields I am setting up a form for multiple users to use, however I would like them to be able to move through the form by tabbing or enter to select fields, i.e. tab from cell a4 to g3 to h20, etc. Can this be done. Confused Tag: Move text Tag: 506253
  - 12
    - scroll lock Hi, I am trying to lock the scroll, My range is "a1:ar31", When i save and close the work sheet and open again the scroll lock range dissappears. is there any code???. please help. Thanks in advance. moiz Tag: Move text Tag: 506250
  - 13
    - How do i make one cell get just the row amount from another cell? I have a Formula that gets data from another tab EXAMPLE: =' TAB NAME'!$C$16 I want to be able to put a number in a different CELL that will change the 16 on the above formula... so if i a put a 19 in A1, the formula will get information from the other tab, in the C Column, and the 19th row... (not real good with excel terminalogy.. sry) Need this for updating a page... with many different column Letters and the same 16, need to change them all by hand at the moment. Thanks in Advance (please give examples as i may not understand it right away =P) Tag: Move text Tag: 506247
  - 14
    - formatting in different countries I've recently created a spreadsheet which contains a date formatted to show as the day of the week by means of "dddd". However this spreadsheet is to be used in Germany and France and I've discovered that in order for the formatting to work, "dddd" has to be replaced with "tttt" in Germany (for Tag) and "jjjj" in France (jour). I'm quite surprised by this as I though that the formatting would have been taken care of in Excel regardless of the country it was being opened. Is this a problem anyone else has encountered and how did you get around it? Libby Tag: Move text Tag: 506245
  - 15
    - Need formula Hi, Don't know does this forumula exists in Excel so I need help. I need to count different values in range of cells. Example: I have cell ranges with this values: 13, 14, 15, 16, 13, 13, 16 I need formula which will return: 3 values of 13 1 value of 14 1 value od 15 2 values of 16. Is this possible in Excel? Thank you in advance. Regards. -- Pozdrav, M http://www.unreal-net.com/ Jedini web imenik na kojem mozete zaraditi! http://forum.unreal-net.com/ Jedini forum koji dijeli zaradu sa clanovima! Tag: Move text Tag: 506243
  - 16
    - duplicate an array and filter the list based on a grouping I have a list of items in excel that belong to certain groups. (see below) --Sheet 1-- A B 1 Electrical 3.1.1 2 Electrical 3.1.2 3 Electrical 3.1.3 4 Mechanical 3.2.1 5 Mechanical 3.2.2 What I would like to do using array functions is obtain an array of all the items within the same group on another worksheet. (see below) --Sheet 2-- A B 1 Electrical 3.1.1 2 Electrical 3.1.2 3 Electrical 3.1.3 I already have a list of all the distinct items within sheet 1 column A. So this part won't be a problem. Has anybody ever attempted to try this with array functions instead of doing it in VB. If anybody could help me with this or point me in the right direction I would greatly appreciate it. Thanks for any and all help on this subject. Jeff Tag: Move text Tag: 506239
  - 17
    - checking for Match Hi there, I would like to use a function that would look at a number in D1, check to see if it exist in range A1: A8, if the number does exist then display the D1 number in the formula cell, else display the number 1. If Number exist! A B C D E 1 5 25 2 9 3 25 Formula> 25 4 1 5 15 6 8 7 3 8 5 If Number does not exist! A B C D E 1 5 11 2 9 3 25 Formula> 1 4 1 5 15 6 8 7 3 8 5 Thank You for any Help! Craig Tag: Move text Tag: 506235
  - 18
    - vlookup in the row below the target row I have the following table. part start mid end ABCD plan 01-Jan 01-Feb 01-Mar actual/projected 01-Jan 05-Feb 05-Mar EFGH plan 01-Feb 01-Mar 01-Apr actual/projected 10-Feb 10-Mar 10-Apr With this vlookup formula, I can lookup the plan date - =VLOOKUP("ABCD plan",A2:D5,2,FALSE) but I really want to capture the actual/projected date in the row below the plan row. How do I do this? -- Alan Tag: Move text Tag: 506229
  - 19
    - Como criar uma formula que ao atingir uma data esta muda de cor Como posso criar uma formula em Excel/2007 para ao atingir uma data esta muda de cor. exemplo: 10/08/08, quando em tempo real for este dia a data muda para vermelho e como fazer tambÃ©m que o sistema me avise que faltam n? de dias para atingir a data em questÃ£o Tag: Move text Tag: 506225
  - 20
    - VLOOKUP using 2 Cells What I want is the lookup to use cells B2 and B3 when it looks up a value Here is my formula now: =VLOOKUP($B$2&$B$3, 'Apr Sups'!$B$2:$J$13,6,0) What am I doing wrong? Tag: Move text Tag: 506210
  - 21
    - day increasing by 1 when i drag and drop when I drag and drop a date format the day value increases by one. how do I stop this? Thank you Tag: Move text Tag: 506208
  - 22
    - Format Name Can someone please help with a formula? In Column A I have names formatted as SMITH, John. In Column B I need John Smith. Would someone please help with a formula that would switch the names, get rid of the comma, and change the case to lower case of the last name except for the first letter? Thanks in advance! - D. Tag: Move text Tag: 506205
  - 23
    - creating sub worksheets Is it possible to group individual worksheets under one general tab??? For example: grouping all of May's worksheets under a specific tab for the month of May???? Tag: Move text Tag: 506204
  - 24
    - 3 variable lookup I'm newly impressed with what Excel can allow me to do, but am running into an issue which may or maynot be doable...so please help if you can: I want to find the sales number for a company by year in a sheet that is organized as follows: Column 1 starting row3: Sales Row 1 starting column 2: Company Name Row 3 starting column2: Year company A A A B B B Year 2007 2006 2005 2007 2006 2005 sales 1.20 2.29 2.17 1.14 3.75 3.57 assets 0.90 1.06 1.06 0.47 1.67 1.46 hlookup only works if I want to find sales by year but the additional variable of company name...maybe I'm just not seeing a simple way to do it...? Tag: Move text Tag: 506203
  - 25
    - =?Utf-8?Q?Danish_Question_H=C3=86LDNING?= Hi all, For some reason my Danish Excel wont recognize "HÃ?LDNING"? Even copy-paste from the help file won't help and it is not on the drop down menu when I write H. Any clue why? Thanx! Tag: Move text Tag: 506197
- Next
  - 1
    - SUM if conditions are met over multiple worksheets I am trying to get the sum of all costs in my work book that correspond to a certain reason. I have a summary page with the follwing list: Total $ Amount Architect Design Issues $0.00 Owner Request $0.00 Construction Deficiency $0.00 Errors & Omissions $0.00 CM / Scope Issues $0.00 DSA / Code Requirements$0.00 Unforeseen Conditions $0.00 Value Engineering $0.00 $- I have a separate work sheet for all contracts. Each work sheet has a list of changes to the contract. The sheets have separate columns for description, cost and reason. The reason code can be selected from a list. I want the summary page to total all costs with associated reason. For example I want it to sum the costs of all changes that have a reason code of "Architect Design Issues" Tag: Move text Tag: 506195
  - 2
    - Conditional Result based on Multiple Columns I have 3 conditions defined across 3 columns of data, each with 0's or 1's depending on partnership status of an account. If all three conditions / columns are 0, then it is a company direct account. I want to consolidate the date into 1 column (Company Direct, Partnered on Brand Y, Partnered on Brand X, Partner Direct). Would someone please suggest a formula for this, I rarely work with Excel and it is a Friday . . . Tag: Move text Tag: 506194
  - 3
    - Using Sumif On Two Columns of Data - How? Here is the problem in a nutshell: Column 1 Column 2 58000 100% 7000 50% 7000 50% 50000 50% 50000 50% I need a function that adds all values in column 1 that are 20000 or higher AND are 50% in column 2, lastly I divide the result by two. I tried something like this: =SUMIF(M158:M163, "50%", (L158:L163,">19999")/2 Didn't work. The correct output using the sample numbers above is 50000.00 Thanks! Tag: Move text Tag: 506187
  - 4
    - Vlookup formula - help please...(soth) Hi Sheet A, Sheet B, Column B Column C Column D 101 130 Consulting 103 101 Training 110 120 Hardware 120 103 Software I'd like to have a formula in column E, that is, if items in 'Sheet A' Column B Matches with items in 'Sheet B' Column C, then enter the result in Column D, such as 'Training' Is this something can be done? Thank you, Soth Tag: Move text Tag: 506186
  - 5
    - vlookup and Sum unique values Hello, I am trying to do a vlookup on Group Names and return a sum of the unique values only. I have many Group names all over this sheet and much of this is repeated (It is important for that sheet). However I just need to have a sum of all unique values. For example Column A Column B Group Name Number in Group F8 20 F7 30 F7 5 F8 20 F7 10 F8 5 F7 30 F7 5 F8 15 F8 5 F8 15 The reu;lt would return a total of 40 for F8(20 + 15 + 5) and a total of 45 for F7 (30 + 5 + 10) Thanks chris Tag: Move text Tag: 506181
  - 6
    - select multiple records in database given conditions I would like to select multiple records from a database matching certain conditions and then extract the information from the record to print on a form. Am using Excel 2003. Tag: Move text Tag: 506180
  - 7
    - What-If Analysis Hello, I am trying to conduct a â??what-ifâ?? analysis for a fairly simple financial model. This model is basically one extensive income statement that contains historical data as well as forward-looking statements. Historical data is hard-coded while the forecast data is driven by revenue, expense, and other miscellaneous assumptions. At any given point, I want to manipulate the revenue assumption for the upcoming period to see what the effect would be, not only on that period, but for all future periods. Clearly, the easiest way to do this would be to punch in different assumptions to see what the outcome would be. However, I want to develop something that would outline multiple outcomes (for example, 10%, 30%, or 50% growths) of these revenue adjustments all at the same time. I tried using scenarios (under Tools>Scenarios) and that works great except that it cannot show multiple outcomes all on one page at the same time. I messed around with â??Summaryâ?? function under scenarios, but those outputs seem gear towards one-time analysis rather than for something that would need to be revisited each month. I was wondering if there is any other way to get the Scenarios to â??publishâ?? the effects of different inputs as a separate report that has more functionality and transparency. I also tried using data tables, which work fine if I just want to see different outcomes for one period, but if I want to see how those one period changes would affect other future periods, I would need to build additional steps to implement it into my main model (toggle switches, etc.) Any help/insight will be appreciated! Tag: Move text Tag: 506178
  - 8
    - Row_Calculation I have a for a formula in a macro: ActiveCell.FormulaR1C1 = _ "=MID(R[-11]C,FIND("","",R[-11]C,1)+2,10) & "" "" & MID(R[-11]C,FIND(""D_"",R[-11]C,1)+2,FIND("","",R[-11]C,1)-FIND(""D_"",R[-11]C,1)-2)" I need to replace the "-11" with a variable name that I calculate prior to this. Can I do this? If so, I need your help. I still trying to understand macros. thanks for looking. El Bee. Tag: Move text Tag: 506176
  - 9
    - Summing cells containing dates I need to add up the total number of cells in a column that contain entries. THe entries are dates i..e, Column A March 3, 2008 Feb 2, 2008 Aprril 3, 2008 June 14, 2008 (sum should = 4 for the total number of cells with entries in the column) Tag: Move text Tag: 506162
  - 10
    - REMOVE THE #DIV/0! ERROR FROM FORMULA WHEN FIGURING MULTIPLE AVERA I am trying to formulate a cell to figure averages from cells that have averages. My current formula reads =AVERAGE(D33,G33,J33,M33,P33,S33,V33,Y33) I am getting the error due to blank cells that have not been filled in yet. Any suggestions? Tag: Move text Tag: 506155
  - 11
    - HELP!! I need help. i have a worksheet that is set up in columns like: id acct no amount I have 250 rows of data and a lots of columns Whiat I would like to do is set it up so that the rows look like this id account amount for all. is there a way to do a macro that will take all the data by column and move it to a row and continue without overwriting the data? Any help will be greatly appreciated Tag: Move text Tag: 506153
  - 12
    - Comparing sets of data, where criteria met, sum certain columns. Microsoft 2003 - I have to compare data extracted from one application to data extracted from another application and resolve all discrpancies between the two files. Any ideas on how to do this? The file has 8 columns - 4 from one application and 4 from the other application (columns a1:d55 is company "XYZ", columns e1:h500 is company "ABC"). I need the formula to subtract the contents of column 'd' from column 'h' where contents of column 'a' are found in column 'e'. These are not always on the same row. Sometimes the match occurs on row one of column 'a' and row three of column 'e'. In addition it is also possible that no match is found at all. Any suggestions would be appreciated. Thanks. Tag: Move text Tag: 506152
  - 13
    - Creating multiple workbooks Is there anyway I can use information on an excel worksheet to create multiple files? I have data on say 'Tab1'. I have subtotalled data by cost centers. Can I get a new file created in excel for each cost center ? Can I have a naming sequence assigned to this? Tag: Move text Tag: 506150
  - 14
    - Merged cells withing Protected Sheets I have a range of cells that we merged and then unlocked. When we protect the sheet and say the user can only go to the unloced cells. We can tab thru until we get to the cell that created from a group of cells merged. it will then tab to the next cell and just keep going back and forth between those two forever. Any suggestions? Tag: Move text Tag: 506145
  - 15
    - date ranges This is probable very simple and I am just overlooking it. But can some tell me how to find out if a date range falls between or overlaps another date range?? Tab 1 contains start and stop vacation dates, tab 2 contains start and stop blackout dates. I need to list on Tab C2 if the persons vacation is in a blackout date or not. Tab1 A B 1 Start End 2 1/1/08 5/1/08 3 2/1/08 2/30/08 Tab2 A B 1 Start End 2 2/1/08 6/1/08 3 2/1/08 2/30/08 Thanks in advanceâ?¦. Tag: Move text Tag: 506143
  - 16
    - Calculating specific increments of time across days I have dates & times which I need to enter (which is the easy part). However, I need to use the difference (in hours) to calculate the cost incurred when the hours fall between 0600 -1800 (day cost) and 1800-0600 (night cost). If the hours fall between day cost hours, then I want a specific cell to calculate the difference in hours in decimal form. If the hours fall between night hours, then I want the difference to calculate in another row. For example: A B C (day cost) D (night cost) 1 3/3/08 06:15 3/5/08 16:45 # hours # hours I don't know if this is possible, but if it is, it will save me tons of time. Right now I am manually inputting the increments to separate night and day cost hours and having excel calculate the rest. Thanks! -- ELG Tag: Move text Tag: 506131
  - 17
    - email Button Hello All, I'm trying to create a button that when pressed it sends an email to a specific email address. That is... Button 1 pressed send current worksheet to address 123@4567.com Button 2 pressed send current worksheet to address 321@7654.com & so on Thnx, BadRasta Tag: Move text Tag: 506129
  - 18
    - Use formula to populate cells Hello All, I have a Workbook with 3 worksheets Sheet1 called quote form Sheet2 called Help Sheet3 called Data In Sheet1 I have the following information... Cell A4 - To: B4 Imnot Kim Cell A5 - E-mail: B5 "Populate" Cell A6 - Phone: B6 "Populate" Cell A7 - Fax: B7 "Populate" in Sheet2 I have non related data to what I'm trying to accomplish Sheet3 I have the following information... Name Contact Tel Fax Email Address Imnot Kim Ron 905.123.4567 905.123.4567 123@4567.ca Yournot Kim Paul 416.123.4567 905.123.4568 123@4568.ca Whose Kim Sandy 604.123.4567 905.123.4569 123@4569.ca Wheres Kim Antonie 780.123.4567 905.123.4570 123@4570.ca Hi Kim Sheldon 403.123.4567 905.123.4571 123@4571.ca By Kim Rose 205.123.4567 905.123.4572 123@4572.ca Here's my dilemma, when I type in Imnot Kim in cell B4 I would like Cell B5-B7 to retrieve and populate the corresponding information from the data sheet. Once again Thnx, Badrasta Tag: Move text Tag: 506123
  - 19
    - Conditional formatting troubleshooting I'm trying to apply conditional formatting to a column of cells. The formula for these cells is =IF(L8<$B$4,"Late!","Ok") and that is filled down the column. In the conditional formatting section, I've tried to apply the following conditions: Condition 1 Formula Is = ISERROR(reference) [if there's an error, puts #VALUE! in white font] Condition 2 Cell Value Is equal to ="Ok" [if the cell value is Ok, puts Ok in black font] Condition 3 Cell Value Is equal to ="Late!" [if cell value is Late!, puts Late! in red font] I have the formatting setting correctly for each of the conditions, according to the previews of the formats. However, regardless of the value in the cell (the error message of #VALUE!, Ok, or Late!), that value is in white font. Any ideas? I'm not sure if the problem is the order of my conditions (I've switched them but it doesn't seem to help) or my using Cell Value Is instead of Formula Is. Thank you!! Tag: Move text Tag: 506117
  - 20
    - Excel question I have what I would think is a fairly simple function that I cannot get for the life of me, if I am looking to write a formula on one spreadsheet using the intersection of 2 values (actual words in this case) can I write a formula that will search vertically for one of the words then search horizontally for the other word and return the value of where these 2 searches meet? I have tried VLOOKUP, HLOOKUP, MATCH and INDEX and am coming up short, any help would be most appreciated! Tag: Move text Tag: 506116
  - 21
    - Multiple functions in one cell Is there a way to write a formula that will leave a cell blank if a specified value is a positive number, but will calculate a percentage if the value is a negative number? I know how to write these formulas separately, but cannot seem to get it right bringing them together in one cell. Not sure if this is even possible. -- cgroninger Tag: Move text Tag: 506106
  - 22
    - Pivot table field missing initially when the pivot table is created all the fileds show in the field list. After amendments the hours field disappears from the field list although it is still on the the pivot table. Any ideas why thisi s happening Thanks Diane Tag: Move text Tag: 506100
  - 23
    - Deleting duplicates in Excel I know that to delete duplicates in a spreadsheet I use Advance Filter-unique records only. However, some of the lists I use requires that both of the items in that list need to be deleted. For instance, I have a list of all our patrons. We have a separate list of patrons that already purchased tickets to the next performance. We need to send an invitation to our patrons to attend this performance. Obviously, we don't want to send invitations to those who have already purchased tickets to this. Is there a way to do this other than manually deleting both entries? Tag: Move text Tag: 506098
  - 24
    - Pivot table filed defaults A client's pivot table always gives 'count' in the data area even on a numeric field. Is there any way to set the default to always show 'sum'? i thought this was the default. Any ideas why this is happening? Thanks Diane Tag: Move text Tag: 506097
  - 25
    - copy cell with macro and increment down each time I need to create a macro that copies two adjacent cells A148 & B148 (same cells each time but with a different value each time) and pastes them into another column but moving down one row each time. The object is to retain the previous values ultimately resulting in a column of various data values. I am able to copy and paste with a macro but when run, it overwrites the previous value because the paste was assigned to a particular cell. Or, is it somehow possible to store the first set of values elsewhere before overwriting? Tag: Move text Tag: 506096

Sh1 C5:C40 are text values inserted at various times and not in any order.
Sh1 D5:D40 are numbers that were inserted next to name and Sh1 E5:E:40 are
additional text values added. In Sh2 C5:C40 are the same text values as Sh1
C5:C40 but in alphabetical order. I am using the SUMIF formula to enter
number values into Sh2 D5:D40. Therefore Sh2 D5 formula is
SUMIF(C5:C40,C2,D5:D40) etc. I want to fill Sh2 E5:E40 with info from Sh1
E5:E40 same as previous col but cannot use sumif because Sh1colE is text.
What formula works?
Thanks

Top

Re: Move text by Pete_UK

Pete_UK
Sat May 10 19:28:34 CDT 2008

Try this in E5:

=3DVLOOKUP(C5,Sh1!C$5:E$40,3,0)

and copy down to E40.

Hope this helps.

Pete

On May 10, 11:34=A0pm, bgkgmg <bgk...@discussions.microsoft.com> wrote:
> Sh1 C5:C40 are text values inserted at various times and not in any order.=
=A0
> Sh1 D5:D40 are numbers that were inserted next to name and Sh1 E5:E:40 are=

> additional text values added. =A0In Sh2 C5:C40 are the same text values as=
Sh1
> C5:C40 but in alphabetical order. =A0I am using the SUMIF formula to enter=

> number values into Sh2 D5:D40. =A0Therefore Sh2 D5 formula is
> SUMIF(C5:C40,C2,D5:D40) etc. =A0I want to fill Sh2 E5:E40 with info from S=
h1
> E5:E40 same as previous col but cannot use sumif because Sh1colE is text.
> What formula works?
> Thanks =A0

Top