jamiguel77
Active Member
- Joined
- Feb 14, 2006
- Messages
- 387
- Office Version
- 2016
- 2010
- 2007
- Platform
- Windows
- Web
hi all, on I4 exist a Error, right?
how to drwa Font Bold on cell (same row), C4
thanks
how to drwa Font Bold on cell (same row), C4
Libro2 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | PEDIMENTO IMP | FECHA | MATERIAL | CANTIDAD | VALOR ADUANA USD | FACTIMP | Empresa | ||||||
2 | 19 67 3435 9001528 | 9001528 | 9001528 | 07-ene-19 | ARNES DE USO AUTOMOTRIZ | 8850 | 53,809.19 | LCCH-0043 | MINGHUA | 8004456 | BMW | ||
3 | 19 67 3435 9001529 | 9001529 | 9001529 | 07-ene-19 | ARNES DE USO AUTOMOTRIZ | 21600 | 325,520.66 | LCCH-0042 | VW | 8004456 | BMW | ||
4 | 19 67 3435 9001662 | 9001662 | 9001662 | 08-ene-19 | ARNES DE USO AUTOMOTRIZ | 11220 | 69,417.58 | LCCH-0046 | #N/D | 8004456 | BMW | ||
5 | 19 67 3435 9001663 | 9001663 | 9001663 | 08-ene-19 | ARNES DE USO AUTOMOTRIZ | 23848 | 1,695,841.32 | LCH-0047 | BMW | 8004456 | BMW | ||
6 | 19 67 3435 9001664 | 9001664 | 9001664 | 08-ene-19 | ARNES DE USO AUTOMOTRIZ | 31680 | 353,358.25 | LCCH-0045 | #N/D | 8004456 | BMW | ||
7 | 19 67 3435 9004731 | 9004731 | 9004731 | 10-ene-19 | ARNES DE USO AUTOMOTRIZ | 20942 | 129,651.08 | LCCH-0052 | #N/D | 8004456 | BMW | ||
8 | 19 67 3435 9004732 | 9004732 | 9004732 | 10-ene-19 | ARNES DE USO AUTOMOTRIZ | 25984 | 318,800.68 | LCCH-0051 | VW | 8004456 | BMW | ||
9 | 19 67 3435 9001523 | 9001523 | 9001523 | 11-ene-19 | ARNES DE USO AUTOMOTRIZ | 20314 | 1,338,573.53 | LCCH-0054 | BMW | 8004456 | BMW | ||
10 | 19 67 3435 9001523 | 9001523 | 9001523 | 11-ene-19 | ARNES DE USO AUTOMOTRIZ | 10455 | 688,923.22 | LCCH-0054 | BMW | 8004456 | BMW | ||
Hoja1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2:B10 | B2 | =RIGHT(A2,7) |
C2:C10 | C2 | =B2*1 |
I3:I10 | I3 | =VLOOKUP(C3,$J$2:$K$1430,2, FALSE) |
thanks