Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bnsSteve
  • Content: Threads
  • Order by date
  1. bnsSteve

    Excel CountIf formula

    Hello, I'm trying to Count a range of cells (ex: Col C) that starts with "ABC" if it's in a certain month or date range (Col B) I have a helper column for the dates, so if Col A is = January 5, then Col B = 1, Col A = February 13, then Col B = 2 etc. Sample Data would look like this: Col...
  2. bnsSteve

    Cross-Tab Forumla to Count and Sum

    Hi there, I have a Cross-Tab set up that has a list of store location #'s by row and then a list of accounts across the columns. It is totaling up the number of transactions by count and $sum of each each store # to each account The count/sum of transactions fields are made up of 4 txn types...
  3. bnsSteve

    Excel Lookup Function

    Hi There, I'm trying to create a formula that will look at a cell value then run that value against a list and return the description of the corresponding value. I think this has to do with a look up function. Ex: My main worksheet is sheet 1, and I would like the column P to take the value...
  4. bnsSteve

    Count and Sum between dollar ranges

    Hi there, I'm trying to create 4 different columns that would show me the Count records and Sum of the dollar values between specific $dollar ranges. Ex: record 1 = $10.25 record 2 = $30.00 record 3 = $0.21 record 4 = $55.00 record 5 = $101.00 I need to create 4 different dollar ranges...
  5. bnsSteve

    Cell look up

    Hello, Wondering if its possible to create a formula that will take a cell in one sheet and reference a column in another sheet then return a value in that row if the cells match. For example: In Sheet A - cell A1 will take the value in B2 then check all the values in Column A in Sheet B to...
  6. bnsSteve

    Summing dupped amounts

    Hi there, Sorry this has been posted a lot, couldn't find one that I could use as a template. Need to sum up $value on only one record which are duplicated. Ex: Group1 - (Transit) ABC Group2 - (App#) 123 Detail (App#)123 - (Transit) ABC - $1,000 (App#)123 - (Transit) ABC - $1,000 (App#)123...
  7. bnsSteve

    Filtering Group based on string value

    Hi there, I have a bunch of customer ID's that lists their account #'s along with the product code. I'm grouping by Customer ID and would like to filter out the group if that customer holds a specific product. I.,e GH1 - 123 123 - 3214 - ABC 123 - 4567 - CTE 123 - 4581 - SER GH1 - 456...
  8. bnsSteve

    Cell formatting

    Hello, I'm trying to format a cell that is referencing another cell in another sheet, to round to the nearest 1,000 and add 'M' to the end of the number. For example, B6 in my primary sheet is referencing B6 in my Data sheet (=Data!6). It currently shows a currency amount, ex; $387,691. What...
  9. bnsSteve

    Bar chart from cross-tab percentage problem

    Hi there, Sorry for the redundant post I realize this is a pretty well known issue. Tried to Google some solutions but wasn't able to resolve getting the % sign to appear in a bar chart that I have created from a cross-tab. My cross-tab consists of a grouping of age groups that I created a...
  10. bnsSteve

    Formatting excel date field so Crystal reads it as date

    Hi, I'm wondering what the best way to format an excel field that has date format as mm/dd/yyyy to so that crystal reads it as a date field and not date-time or string? I've tried 'text to columns' making the field a date field, but crystal reads it as a date-time. Reason being, I would...
  11. bnsSteve

    Cross tab on a formula or Group on a formula

    Hi, I have data that shows: Account# - Type of Product Any account# can have multiple product types in it, so my data will show repeated acct# with different products assigned to that acct# I've grouped the data by acct# and did a Count on products per acct#. I have then created a formula...
  12. bnsSteve

    Percentage of a summarized grouped field by another sum grouped field

    Hello, I'm trying to get a percentage of a summarized field that is grouped by month by another summarized field that is group by month. (Would like to get the %Worked column below) Ex: Gr.by.month Dist_Cnt_Apps Dist_Cnt_Apps_wrkd %Worked Jan 150 25...
  13. bnsSteve

    Creating Fiscal Quarter Groups

    Hello, I would like to group by quarter, however, I would like to have the quarters be from, Q1=Nov-Jan, Q2=Feb-Apr, Q3=May-July, Q4=Aug-Oct. I'm currently only using 3 fields, date field, product field and product channel field. Any help would be great. Thanks!
  14. bnsSteve

    Excel 2007: Creating secondary axis on chart

    Hello, I would like to create a secondary axis for only 1 of the horizontal groups in my excel bar chart. Ex: Y-axis is dollar amount; X-axis I have 5 different columns, 1) Total $amt, 2)avg $amt, 3)max $, 4)min $, 5)$std dev. Each x-axis column is comparing values for A and B. My problem...
  15. bnsSteve

    Selecting or Suppressing certain rows/groups

    Hi there, I'm wondering if there's a way to suppress or hide a group but only on certain conditions? Ex: GH1 - [Issuer Bob] GH2 - [Client] [count of cert#] D - [Issuer] [Cert#] [Acct#] [Boolean for type of cert] [Client#] [lastname client] [first name client] GH2 - [Client] [count of cert#]...
  16. bnsSteve

    Help connecting from Analysis Services

    Hello, I'm currently connecting to a data cube through the SQL Server Analysis Services using Excel 2007 but would like to access the same cube with Crystal. Not exactly sure if it is possible to create the same connection with crystal or if I have to connect using ODBC? Any thoughts would...
  17. bnsSteve

    more advanced drop down functionality

    Hello, I'm wondering if I could get help in creating a drop down in one cell that when you select an item in the that drop down, it will change what appears in the next drop down. Ex: Cell A1 has drop down with a list of key words. If I select the first key word in that list. I will get a...
  18. bnsSteve

    Excel 2007 drop down functions

    Hello, I've created a drop down in sheet one from a list in sheet two and I am wondering if it is possible so that when you start to type something like the letter "P" into the cell with the drop down, the list will auto populate to the section of the list with all entries starting with "P"...
  19. bnsSteve

    Counting a formula

    Hello, I'm wondering if there's a way to count a formula. For ex: I made a formula saying return "1" if (field1/field2) >0.2. So the formula worked but now I would like to count all the '1' in each group. Thanks!
  20. bnsSteve

    Work around sorting running total

    Hi, Just wondering if anyone has figured out a way to work around sorting a running total? Here's an example of what I would like. I have 2 groups Group 1: CustomerID Group 2: Date Within group 2, there may be 1,2,5,10,etc dates. I used a running total to count the number of dates in...

Part and Inventory Search

Back
Top