Search:

Type: Posts; User: Seba; Keyword(s):

Page 1 of 10 1 2 3 4

Search: Search took 0.03 seconds.

  1. Thank you all for your help. Sdckapr formula...

    Thank you all for your help. Sdckapr formula computed what I needed. One more question, if I want to have the formula give me everything that felt 30 days after the date specify in E2, how would I...
  2. Formula for excel 2010 to compare dates in cells and return sum

    Hello-I am trying to develop a formula where I would take the dates in a column range and compare it to a date on a particular cell. If the return value is true, I would then want it to sum the...
  3. Replies
    9
    Views
    1,208

    Thanks sdckapr. The formula works.

    Thanks sdckapr. The formula works.
  4. Replies
    9
    Views
    1,208

    sdckapr-You are right the list is not sorted and...

    sdckapr-You are right the list is not sorted and unfortunately I can't sort it because we track invoice base on the date they come in and not by invoice number.

    Kweaver-I will try it again and...
  5. Replies
    9
    Views
    1,208

    I couldn't get either formula to work. There is...

    I couldn't get either formula to work. There is an arrow down within the cell that gives me the options to convert text to number, correct error, ignore error, etc.

    Kweaver: Do you need to...
  6. Replies
    9
    Views
    1,208

    Best way to match a cell value on worksheet

    Hello-I am trying to do a vlookup formula but I an not getting the result I want. The reason I think is that some of the cells in the array table are in text format. I have an error that I can pick...
  7. Replies
    11
    Views
    712

    No. It could be in worksheet 2 or 3 or more. ...

    No. It could be in worksheet 2 or 3 or more. Yes the format on how the number was enter will be the same, but the format of the cell I am not too sure. Thanks.
  8. Replies
    11
    Views
    712

    Maud-The answer to number three should be no...

    Maud-The answer to number three should be no (Sorry). However, the invoices number can be found in the same column in the invoice file. The invoice file(s) could have multiple worksheets. Format...
  9. Replies
    11
    Views
    712

    Hi Maud-Thanks for getting back to me. I am...

    Hi Maud-Thanks for getting back to me. I am going to see if I can send sample of both the summary workbook and invoice. I think your take on the general workflow is correct. I want to get a code...
  10. Replies
    11
    Views
    712

    Thanks Maudibe:rolleyes:-One quick question. So...

    Thanks Maudibe:rolleyes:-One quick question. So I want the search to look up all the values say in column B. Instead of giving it a search criteria, I would like it to look at all values in column...
  11. Replies
    4
    Views
    300

    Thank you. With your help I got the formula to...

    Thank you. With your help I got the formula to work.
  12. Replies
    4
    Views
    300

    No I am looking up B2 from column 2 or b in sheet...

    No I am looking up B2 from column 2 or b in sheet 1 masterlog.xls, but returning the value in column 10 that matches b2.
  13. Replies
    11
    Views
    712

    looking up for a cell in multiple files

    Hello-I have Excel 2010 and would like to know if there is a way to accomplish the following goal. I have an excel file that I would like to put a formula to search other excel files in other folder...
  14. Replies
    4
    Views
    300

    lookup or vlookup using Excel 2010

    Hello-I am having a problem with the following vlookup formula. =Vlookup(b2,'c:user\data\[masterlog.xls]sheet1!'a1:d500,10, false). The value that is looking up in the masterlog.xls is in sheet1,...
  15. Replies
    6
    Views
    447

    Thanks that works.

    Thanks that works.
  16. Replies
    6
    Views
    447

    Sorry-MID(B2,5,3). the Budget in the vlookup is...

    Sorry-MID(B2,5,3). the Budget in the vlookup is a label to a range coming from another worksheet in the same spreadsheet
  17. Replies
    6
    Views
    447

    Vlookup where value is a formula

    Hello Everyone-I have MS Excel 10 and need to do a vlookup function. The vlooup function is looking up a cell that has the following formula in it "="1"&mid(5,3) in A2. When I do the vlookup...
  18. Replies
    1
    Views
    1,148

    inputting multiple number on an input box

    Hello-I am doing some VBA for excel 2010 and have some questions about how to have user input multiple numbers in an inputbox field. I am using the index(es) to filter a table. Maybe this is not...
  19. Replies
    1
    Views
    666

    Macro/VBA if statement-Excel 2010

    I am trying to write a VBA if statement. What I would like to do is for the pivot table to only show the PivotItems where the number is 1700 and everything else to not show. Any help would be...
  20. Replies
    0
    Views
    771

    Visio and ADA compliance

    Hello-What is the best way to make a Visio document ADA compliant in PDF? I have Visio 10 and Adobe Acrobat X Professional. I have tried to use both Adobe add-on in Visio and Visio's own PDF...
  21. Replies
    1
    Views
    558

    formula to count unique numbers

    Hello-I need to create a formula that counts unique values in rows. I know I can use the filter option, but need to create a formula. For example
    Row1 "david"
    Row2 "david"
    Row3 "Jessie"
    Row4...
  22. Replies
    3
    Views
    1,286

    Does that mean even when you are not using the...

    Does that mean even when you are not using the Xbox? No. It works fine when not using Xbox.
    Only when you use the Xbox? I get problems loggin into X-box live sometimes and I end up having to...
  23. Replies
    3
    Views
    1,286

    lose network when trying to use Xbox live

    Hello Everyone-lately I been having to reboot my 2wire gateway to be able to connect to x-box live. I have the x-box live connection hardwire into the 2wire gateway and 2 laptops connect wireless. ...
  24. Replies
    10
    Views
    8,655

    JJDetroit-is there a way to encrypt the drive...

    JJDetroit-is there a way to encrypt the drive before putting it on to a Pogoplug? I have to USB harddrive that I will be using with the Pogoplug, but I am afraid to put sensative information there...
  25. Replies
    5
    Views
    1,161

    I have a database that has a form to track...

    I have a database that has a form to track information that I do everyday. Sometimes I get request via email to do a task that I need to include in the tracking form of the database. I would like to...
Results 1 to 25 of 246
Page 1 of 10 1 2 3 4