Search results

Thank you Hui, It worked really nice. I tried the same thing for a label but is not working. Any suggestions for a code that will update the cells in "sh1" with the new info from textboxes ?

Hello! I have one sheet(say SH1)with data in A1:C2. I want to create a form in VB with 2 Labels(L1 & L2) and 4 Text Boxes(TB1 to TB4). What I would like to accomplish is to have L1 showing data from cell A1 and L2 from A2. Also I want TB1 to show data from B1, TB2 from B2, TB3 from C1, TB4...

Thank you. Everything is working really nice.

Hello, The formulas are working really nice. One more thing: it is possible to have the cell address to be split in 2 cells? Ex: $B$2 in cell E1 as "B" in F1 and "2" in G1? Thank you.

Hello, To be more specific the values in the table are unique and by "next upper number" I mean next higher value than C1. Sorry for not being clear. Thank you.

Hello, I need some help finding the next upper number from a table. For example table has 2x2 data A1:B2 C1 has a number in the range of my table. I want D1 to show the next number above C1 from my table. Also it is possible to identify the location of the number showed in D1? Any idea...

Hi, I have a col. that takes data from 6 different tables. When I update a cell in a table the column will automatic update. Is there a way to stop this automatic update until I give permission? Each update takes 30-45 sec (for updating one cell in a table) and to update a row in a table it...

Hi, For some reasons I am not able to upload any files from this computer. I just discovered what is going on: formula is working only if i start with cell A1 down, but I need A1 for a header because without header I am not able to filter data for unique values. As you can see I am going in...

Hi Narayank991, I found out that the formula you put it here (thank you)has a small problem (it took me 2 day to discover it). Formula is omitting the minimum value from the tables(for instance I went with only one value in each table and the min value was not return). Any idea to fix it...

Hi, I used a macro and is working perfect. Thanks for your advice.

Hi Jai, I inserted a header row and It's working. Is there a way to make excel filtering automatic? My data will change every other day and I saw that the data it is filtered only when I retake the whole process of filtering. Thank you.

Hi, Advanced filtering is returning only one value(the first value from column A) and I have this message:"The extract range has a missing or illegal field name". In column A are only numbers so no special characters. One more thing: all cells in col. A have associated a formula (I am...

Hi Jai, I tried with advanced filtering but for some reason is not returning the right result. I was thinking perhaps a formula will fix this problem. Col A has apx 350 data entry(some of them unique), in col B perhaps will be apx.10-12 values. Thanks

Hi, Col. A has values that repeat 2 or more times. Col.B needs only one of each of the values from column A. I tried with Data/Remove duplicates but is not what I want. Any ideas? Thank you

Hi, I moved the first table to a new field B2:C10 because it was interfering with the formula and is working. There is another bump in the road: the formula brings the SAME number as many times the date frame allows(1, 2 3 .. times)and I need every available number only once. My mistake, I...

Hi, The above formula brings the first correct number in the cell A1 but when it is copied into the next cells brings the same number instead of the next, and next ... number. Any suggestions? Thank you.

Hello, In "Main" table in cell A1 should be for example 111, in cell B1 should be 222, in C1 should be 333 and so on only if the date attached to each number is in range B2 to B3(from Main) Thank you

Hello, I have 3 Tables: "Main" A B C D 1 2 Start Date:"B2" 3 End Date: "B3" Table A A B 1 111 "Date" 2 111 "Date" 3 222 "Date" Table B A B 1 111 "Date" 2 111 "Date" 3 333 "Date" 4 444 "Date" I want row...

Hello, In cell A1 I have a formula that gives me a value. When I eliminate 1 variable the result is #N/A. I need cell B1 to copy the final result from A1 or if there(A1) is #N/A, I want this cell(B1) to be empty. I tried this: =IF(A1="#N/A","",A1)but is still returning #N/A. Any ideas?

I found out where was the error.Instead of AB$2 at second Match should be AB$1. Now is working perfect. Great solution ! Thank you.

I tried both solutions and I got an error every time. This formula brings the job # and not the value corresponding to Job# and the month.Do you know how to fix it?

Hello, I have 2 tables, one with data and the other one needs to update from the firs one according to the job # I input.This is an example: Table 1: job# Jun-12 Jul-12 Aug-12 Sept-12 ..... 333 55 71 23 14 111 19 83 222...