blocking 2 cells together (name and number)

A

array41

New Member
Joined
May 30, 2007
Messages
5
Hi,

I have a question. I am currently making a database.The thing is I have 2 tables : one with all the information and the other one is the resume for the graph. Moreover I have used the array programme for this table so that all my data are now ordered from the largest to the smallest.

I would like to block the cell of this last table so that each time the numbers change, the name in relation with this number will change too.
With the array, the result will change from place depending on the evolution of our market. That s why I would need to block this 2 cells.

I know that my explanations are a little bit complicated but first english is not my mother language and secondly I can't even find the right word in my mother language.

Can you please help me?
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Sort by date Sort by votes
Welcome to the Board!

You might want to post in the International Forum (Questions in other languages).

Barring that can you post a shot of what you've got and what you want as a result? Take a look under my sig line for the link to Colo's HTML Maker which will let you do that.

Smitty
 
Upvote 0
please can someone help me

I posted my questions yesterday and didn't get any answer that could help me
 
Upvote 0
You didn't give any more detail as to what you need.

If by blocking two cells you're trying to join them you might be looking at concatenation, which you can do like this:

=A1&B1

Hope that helps,

Smitty
 
Upvote 0
Here is another explanation maybe it will help...
I have created a table so that every changes or evolutions of values will be automatic (using array to sort it out from the largest to the smallest values).
Each value correspond to a name. the problem is if the value is changing and so changing from cell ( because of array) the name is not following the value. That mean that all the result is totally false.
 
Upvote 0
You must log in or register to reply here.

Similar threads

O
  • Solved
What Is Best Practice To Facilitate Column Layout Change In A Project?
Replies
2
Views
209
ozex
O
R
  • Solved
Character count on each line within one cell
2 3
Replies
27
Views
348
ramesanscesse
R
P
  • Question Question
TypeScript (or other solutions) for modifying given list of cells (and similar problems)
Replies
0
Views
112
Pingaware
P
V
  • Question Question
Excel: drop down list colouring based on "dependent" list
Replies
5
Views
161
Peter_SSs
Peter_SSs
G
  • Solved
Filter columns (number of rows keeps changing)
Replies
1
Views
307
myall_blues
myall_blues

Forum statistics

Threads
1,223,970
Messages
6,175,699
Members
452,667
Latest member
vanessavalentino83

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top